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
