hholzgra Tue Dec 25 18:54:29 2007 UTC Added files: (Branch: PHP_5_3) /php-src/ext/mysqli/tests bug42548.phpt
Modified files: /php-src NEWS Log: MFH: Fix for bug #42548 "PROCEDURE xxx can't return a result set" http://cvs.php.net/viewvc.cgi/php-src/NEWS?r1=1.2027.2.547.2.965.2.59&r2=1.2027.2.547.2.965.2.60&diff_format=u Index: php-src/NEWS diff -u php-src/NEWS:1.2027.2.547.2.965.2.59 php-src/NEWS:1.2027.2.547.2.965.2.60 --- php-src/NEWS:1.2027.2.547.2.965.2.59 Mon Dec 17 10:02:12 2007 +++ php-src/NEWS Tue Dec 25 18:54:29 2007 @@ -77,6 +77,7 @@ - Fixed bug #42657 (ini_get() returns incorrect value when default is NULL). (Jani) - Fixed bug #42637 (SoapFault : Only http and https are allowed). (Bill Moran) +- Fixed bug #42548 (mysqli PROCEDURE calls can't return result sets). (hartmut) - Fixed bug #42509 (gmp leaks memory when gmp_init() not used). (Stas) - Fixed bug #42284 (duplicate of #39700). (Lars W) - Fixed bug #42069 (parse_ini_file() allows using some non-alpha numeric http://cvs.php.net/viewvc.cgi/php-src/ext/mysqli/tests/bug42548.phpt?view=markup&rev=1.1 Index: php-src/ext/mysqli/tests/bug42548.phpt +++ php-src/ext/mysqli/tests/bug42548.phpt --TEST-- Bug #42548 PROCEDURE xxx can't return a result set in the given context (works in 5.2.3!!) --SKIPIF-- <?php if (!extension_loaded("mysqli")) print "skip"; ?> --FILE-- <?php $mysqli = mysqli_init(); $mysqli->real_connect('localhost', 'root', '', 'test'); if (mysqli_connect_errno()) { printf("Connect failed: %s\n", mysqli_connect_error()); exit(); } $mysqli->query("DROP PROCEDURE IF EXISTS p1") or die($mysqli->error); $mysqli->query("CREATE PROCEDURE p1() BEGIN SELECT 23; SELECT 42; END") or die($mysqli->error); if ($mysqli->multi_query("CALL p1();")) { do { if ($objResult = $mysqli->store_result()) { while ($row = $objResult->fetch_assoc()) { print_r($row); } $objResult->close(); if ($mysqli->more_results()) { print "----- next result -----------\n"; } } else { print "no results found"; } } while ($mysqli->more_results() && $mysqli->next_result()); } else { print $mysqli->error; } $mysqli->query("DROP PROCEDURE p1") or die($mysqli->error); $mysqli->close(); ?> --EXPECT-- Array ( [23] => 23 ) ----- next result ----------- Array ( [42] => 42 ) ----- next result ----------- no results found -- PHP CVS Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php