ID: 39134 User updated by: jr-phpbugs at cedric dot unob dot cz Reported By: jr-phpbugs at cedric dot unob dot cz Status: Open Bug Type: MSSQL related Operating System: linux (irrelevant) PHP Version: 4.4.4 New Comment:
Since I omitted double-quotes at the end of the query, here's the corrected one: $query="SELECT test_text FROM test WHERE test_id=2"; Previous Comments: ------------------------------------------------------------------------ [2006-10-12 08:45:07] jr-phpbugs at cedric dot unob dot cz Description: ------------ PHP, compiled with --with-sybase-ct=/usr/localFreeTDS crashes with segmentation fault on SELECT from column of type TEXT with empty string value. Observed on PHP compiled with --with-sybase-ct=/path/to/freetds-0.64/prefix , against MSSQL server 2000 Affects FreeTDS 0.64 and 0.64.1 (with 'post64.patch.gz' applied). Has not been observed with FreeTDS 0.63. FreeTDS 0.64 alone (without PHP) is not affected. Possible bug in ext/sybase_ct/php_sybase_ct.c Reproduce code: --------------- in MSSQL Enterprise manager: CREATE TABLE [dbo].[TEST] ( [TEST_ID] [int] IDENTITY (1, 1) NOT NULL , [TEST_VALUE] [int] NOT NULL , [TEST_TEXT] [text] NULL ) insert into TEST (TEST_VALUE) values ('5'); insert into TEST (TEST_VALUE,TEST_TEXT) values ('6',''); in PHP script: ... $query="SELECT test_text FROM test WHERE test_id=2; $res=mssql_query($query,$db); Expected result: ---------------- Empty string. Actual result: -------------- PHP crashes with segmentation fault. CLI version: - crash with "segmentation fault" message libphp4.so version: - affected thread produces a line "[notice] child pid XXXXX exit signal Segmentation fault (11)" in Apache's error log. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=39134&edit=1