#45099 [NEW]: PROCEDURE xxx can't return a result set in the given context(same as in mysqli)

From: carsten at brandt-henke dot de Operating system: Linux (all?) PHP version: 5.2.6 PHP Bug Type: MySQL related Bug description: PROCEDURE xxx can't return a result set in the given context(same as in mysqli) Description: ------------ same problem as described here for mysqli ( http://bugs.php.net/bug.php?id=42548 ) seems to exist in the mysql extension. I get the same error message when trying to call a PROCEDURE in MySQL. The Error-Message: 1312 - PROCEDURE databsename.select_user_login can't return a result set in the given context ) Reproduce code: --------------- procedure has been added by sql-query: DELIMITER | CREATE PROCEDURE select_user_login ( IN v_email varchar(128), IN v_password varchar(32) ) BEGIN SELECT user_id, username FROM user WHERE user.email = v_email; END| DELIMITER ; ------- php-code: $res = mysql_query("CALL select_user_login('$email', '$pw')"); Expected result: ---------------- well, no error ;-) Actual result: -------------- MySQL-Error 1312 - PROCEDURE databsename.select_user_login can't return a result set in the given context ) -- Edit bug report at http://bugs.php.net/?id=45099&edit=1 -- Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=45099&r=trysnapshot52 Try a CVS snapshot (PHP 5.3): http://bugs.php.net/fix.php?id=45099&r=trysnapshot53 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=45099&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=45099&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=45099&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=45099&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=45099&r=needscript Try newer version: http://bugs.php.net/fix.php?id=45099&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=45099&r=support Expected behavior: http://bugs.php.net/fix.php?id=45099&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=45099&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=45099&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=45099&r=globals PHP 4 support discontinued: http://bugs.php.net/fix.php?id=45099&r=php4 Daylight Savings: http://bugs.php.net/fix.php?id=45099&r=dst IIS Stability: http://bugs.php.net/fix.php?id=45099&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=45099&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=45099&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=45099&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=45099&r=mysqlcfg