#27843 [Opn->Ver]: sybase_query() triggers (spurious?) notices when query is a stored procedure

From: Date: Tue, 13 Apr 2004 21:49:32 +0000
Subject: #27843 [Opn->Ver]: sybase_query() triggers (spurious?) notices when query is a stored procedure
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-58089@lists.php.net to get a copy of this message 
 ID:               27843
 Updated by:       sniper@php.net
 Reported By:      michaels at crye-leike dot com
-Status:           Open
+Status:           Verified
 Bug Type:         Sybase-ct (ctlib) related
-Operating System: Linux
+Operating System: *
-PHP Version:      4.3.5
+PHP Version:      4CVS, 5CVS (2004-04-13)


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] sniper@php.net

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

Thread (9 messages)

« previous php.bugs (#58089) next »