Bug #63949 [Com]: selects on long varchar fields returns empty with PDO ODBC

Edit report at https://bugs.php.net/bug.php?id=63949&edit=1 ID: 63949 Comment by: ivaldo dot oliveira at gmail dot com Reported by: toebs at pubsqrd dot com Summary: selects on long varchar fields returns empty with PDO ODBC Status: Open Type: Bug Package: PDO ODBC Operating System: Amazon Linux PHP Version: 5.4.10 Block user comment: N Private report: N New Comment: This problem still exists in version 7.2.2. My column is varchar (300) and my database is the Intersystems Cache. Thanks for help. Previous Comments: ------------------------------------------------------------------------ [2017-04-14 18:42:09] daniel at ringhisercomputersolutions dot com This problem still exists in version 7.0.15. Why is this not being fixed? ------------------------------------------------------------------------ [2013-02-20 06:22:37] cyberitas at gmail dot com We're also seeing the same sigsegv mentioned in the previous comment with pdo+odbc with MS-SQL via freetds ODBC. Selecting from a column defined as varchar(256) any of the fetch functions lead to a segfault. Program received signal SIGSEGV, Segmentation fault. 0x00002aaab393010b in ?? () from /usr/lib64/libodbccr.so.1 (gdb) info stack #0 0x00002aaab393010b in ?? () from /usr/lib64/libodbccr.so.1 #1 0x00002aaab013648d in SQLGetData () from /usr/lib64/libodbc.so.1 #2 0x00002aaab059d288 in ?? () from /usr/lib64/php/modules/pdo_odbc.so #3 0x00002aaab038d920 in ?? () from /usr/lib64/php/modules/pdo.so #4 0x00002aaab038e56e in ?? () from /usr/lib64/php/modules/pdo.so #5 0x00002aaab038f7fc in ?? () from /usr/lib64/php/modules/pdo.so #6 0x00000000005e78e9 in ?? () #7 0x00000000005bd9ab in execute () #8 0x0000000000599f45 in zend_execute_scripts () #9 0x000000000054ad48 in php_execute_script () #10 0x0000000000622cde in ?? () #11 0x00000034b5e1d9c4 in __libc_start_main () from /lib64/libc.so.6 #12 0x0000000000421789 in _start () ------------------------------------------------------------------------ [2013-01-30 00:38:14] paul dot posts at gmail dot com Apologies, our testing showed that cast to text was not a viable workaround. ------------------------------------------------------------------------ [2013-01-30 00:08:44] paul dot posts at gmail dot com Also seeing this using pdo+odbc with MSSQL 2012. varchar(max) and varchar(256) columns were both causing heap overflow. Casting the columns to a text column resulted in returning the correct data as a workaround. ------------------------------------------------------------------------ [2013-01-09 08:41:31] toebs at pubsqrd dot com Typo in the email address. Correct email is "toebs@pubsqrd.com". ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at https://bugs.php.net/bug.php?id=63949 -- Edit this bug report at https://bugs.php.net/bug.php?id=63949&edit=1