Bug #62046 [Opn->Ver]: mysqli@mysqlnd can't iterate over stored sets after call to mysqli_stmt_reset()

Edit report at https://bugs.php.net/bug.php?id=62046&edit=1 ID: 62046 Updated by: andrey@php.net Reported by: andrey@php.net Summary: mysqli@mysqlnd can't iterate over stored sets after call to mysqli_stmt_reset() -Status: Open +Status: Verified Type: Bug Package: MySQLi related Operating System: All PHP Version: 5.3Git-2012-05-16 (Git) -Assigned To: +Assigned To: mysql Block user comment: N Private report: N Previous Comments: ------------------------------------------------------------------------ [2012-05-16 12:14:15] andrey@php.net Description: ------------ mysqlnd's implementation of stmt_reset() has a bug, that stored results sets exist but cannot be read if mysqli_stmt::reset() is called. After reset the data is unavailable. Test script: --------------- <?php $link = new mysqli_connect('127.0.0.1', 'root', 'root', 'test'); $s = $mysqli->prepare('SELECT 42'); $s->execute(); $s->store_result(); $one = NULL; $s->bind_result($one); $s->reset(); while ($s->fetch()) { var_dump($one); } $s->close(); $c->close(); ?> Expected result: ---------------- int(42) Actual result: -------------- nothing ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=62046&edit=1