--TEST-- Bug #32405 (mysqli->fetch() is returning bad data) --SKIPIF-- --FILE-- query("CREATE TABLE test_users(user_id int(10) unsigned NOT NULL auto_increment, login varchar(50) default '', PRIMARY KEY (user_id))"); $link->query('INSERT INTO test_users VALUES (NULL, "user1"), (NULL, "user2"), (NULL, "user3"), (NULL, "user4")'); if ($stmt = $link->prepare("SELECT SQL_NO_CACHE user_id, login FROM test_users")) { $stmt->execute(); $stmt->bind_result($col1, $col2); while ($stmt->fetch()) { var_dump($col1, $col2); } $stmt->close(); } mysqli_query($link,"DROP TABLE test_users"); mysqli_close($link); ?> --CLEAN-- --EXPECTF-- int(1) %s(5) "user1" int(2) %s(5) "user2" int(3) %s(5) "user3" int(4) %s(5) "user4"