From: [EMAIL PROTECTED]
Operating system: Linux
PHP version: 4.3.0RC2
PHP Bug Type: Sybase-ct (ctlib) related
Bug description: sybase_query fail to handle stored procedure result with "nocount"
option
Test script :
<?
$sy = sybase_pconnect('DBHOST', 'user', 'pass');
sybase_select_db('MyDB', $sy);
sybase_query("test_bug 1", $sy);
?>
produce :
Notice: sybase_query() [http://www.php.net/function.sybase-query]: Sybase:
Unexpected results, cancelling current in - on line 4
with test_bug defined as follow :
create procedure test_bug
@input int
AS
BEGIN
set nocount on
select @input 'result'
return 2
END
Removing the "set nocount on" lead to expected result but, of course, in
real wold sp, the nocount option is rarely used for fun...
Build with Sybase ctclient v12.5
Works perfectly well with 4.2.3 and previous.
--
Edit bug report at http://bugs.php.net/?id=20861&edit=1
--
Try a CVS snapshot: http://bugs.php.net/fix.php?id=20861&r=trysnapshot
Fixed in CVS: http://bugs.php.net/fix.php?id=20861&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=20861&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=20861&r=needtrace
Try newer version: http://bugs.php.net/fix.php?id=20861&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=20861&r=support
Expected behavior: http://bugs.php.net/fix.php?id=20861&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=20861&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=20861&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=20861&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=20861&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=20861&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=20861&r=isapi
