From: lo at readyon dot com Operating system: Mac OS X 10.5.7 (9J61) PHP version: 5.2.10 PHP Bug Type: Sybase-ct (ctlib) related Bug description: sybase_ct does not support multiple result sets returned by stored procedures
Description: ------------ Sybase CTLib does not support fetching more than one result set from a stored procedure. This seems to be a long standing issue detailed in the closed (status: bogus) issue #26636 and others, detailed in the user comments on the page http://us3.php.net/manual/en/function.sybase- query.php. Reproduce code: --------------- $conn = sybase_connect($server, $user, $pass); sybase_select_db($db, $conn); $result = sybase_query("sp_help $table", $conn); do { echo "Next result set...\n"; while ($row = sybase_fetch_assoc($result)) { echo " - fetched row...\n"; } } while ($result = sybase_next_result($conn)); // <- No such function Expected result: ---------------- Many result sets, for example: Next result set... - fetched row Next result set... - fetched row - fetched row - fetched row - fetched row - fetched row - fetched row Next result set... - fetched row - fetched row Next result set... - fetched row - fetched row Next result set... - fetched row Next result set... - fetched row Next result set... - fetched row Next result set... - fetched row Next result set... - fetched row Next result set... - fetched row Actual result: -------------- Next result set... - fetched row Then no supported function sybase_next_result(). -- Edit bug report at http://bugs.php.net/?id=48675&edit=1 -- Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=48675&r=trysnapshot52 Try a CVS snapshot (PHP 5.3): http://bugs.php.net/fix.php?id=48675&r=trysnapshot53 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=48675&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=48675&r=fixedcvs Fixed in CVS and need be documented: http://bugs.php.net/fix.php?id=48675&r=needdocs Fixed in release: http://bugs.php.net/fix.php?id=48675&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=48675&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=48675&r=needscript Try newer version: http://bugs.php.net/fix.php?id=48675&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=48675&r=support Expected behavior: http://bugs.php.net/fix.php?id=48675&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=48675&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=48675&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=48675&r=globals PHP 4 support discontinued: http://bugs.php.net/fix.php?id=48675&r=php4 Daylight Savings: http://bugs.php.net/fix.php?id=48675&r=dst IIS Stability: http://bugs.php.net/fix.php?id=48675&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=48675&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=48675&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=48675&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=48675&r=mysqlcfg
