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
