ID: 27843 Updated by: [EMAIL PROTECTED] Reported By: michaels at crye-leike dot com Status: Verified Bug Type: Sybase-ct (ctlib) related Operating System: * PHP Version: 4CVS, 5CVS (2004-04-13) Assigned To: thekid New Comment:
I fixed this bug locally but still have quite an amount of other bugfixes / improvements lying around, which I don't want to separate from this. Maybe you'd like to test the complete patchset available at http://sitten-polizei.de/php/sybase_ct.diff (HEAD) http://sitten-polizei.de/php/sybase_ct4.diff (PHP_4 branch) As soon as I've tested the other changes enough, I'll commit everything to CVS (should be in a couple of days) Previous Comments: ------------------------------------------------------------------------ [2004-04-13 17:39:39] michaels at crye-leike dot com Hi, I tried the PHP snapshot (php4-STABLE-200404131830) and there is no change; the problem still occurs. Thanks... ------------------------------------------------------------------------ [2004-04-13 12:34:46] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php4-STABLE-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-STABLE-latest.zip ------------------------------------------------------------------------ [2004-04-02 12:20:38] michaels at crye-leike dot com Description: ------------ Using FreeTDS 0.62.1 compiled with: ./configure --with-tdsver=4.2 --enable-msdblib --with-gnu-ld --enable-shared --enable-static Using PHP 4.3.5 compiled with: ./configure --with-mysql=/usr/local/mysql/ --enable-track-vars --enable-trans-sid --with-sybase-ct=/usr/local/ --with-pgsql=/usr/local/pgsql/ --enable-xslt --with-xslt-sablot --with-zlib --with-ldap --with-apxs=/usr/local/apache/bin/apxs Using TDS version 7.0 Using Microsoft SQL Server 7.0 It seems that sybase_query() triggers an E_NOTICE ("Sybase: Unexpected results, cancelling current") whenever the query in question is a stored procedure. This notice is not triggered when using either "--with-sybase" or "--with-mssql" (using dblib). For those of us running with an error_reporting level of E_ALL, this causes a problem, as we'd either have to preface every call to sybase_query() with "@" and handle all Sybase errors manually, or lower the error_reporting level. Reproduce code: --------------- <? $dbh = sybase_connect('db_host', 'user', 'pass'); sybase_select_db('db_name', $dbh); sybase_query(" create procedure test_bug as begin select 1 end ", $dbh); sybase_query("exec test_bug", $dbh); sybase_query("drop procedure test_bug", $dbh); ?> Expected result: ---------------- Expected empty output with no notices triggered. Actual result: -------------- Notice: sybase_query(): Sybase: Unexpected results, cancelling current in - on line 13 ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=27843&edit=1
