ID: 27843 Comment by: tvoigt at informatik dot tu-cottbus dot de Reported By: michaels at crye-leike dot com Status: Open Bug Type: Sybase-ct (ctlib) related Operating System: Linux PHP Version: 4.3.5 New Comment:
Hi there! Can reproduce this one with php-4.3.3 and later versions on Linux and Solaris 8 using Sybase OpenClient (not FreeTDS). And WinNT 4 seems to have that problem, too (bug #27842). However, besides that notice all stored procedures work correctly. Best regards, Thomas Previous Comments: ------------------------------------------------------------------------ [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