bug31668.phpt 1.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960
  1. --TEST--
  2. Bug #31668 (multi_query works exactly every other time (multi_query was global, now per connection))
  3. --EXTENSIONS--
  4. mysqli
  5. --SKIPIF--
  6. <?php
  7. require_once('skipifconnectfailure.inc');
  8. ?>
  9. --FILE--
  10. <?php
  11. require_once("connect.inc");
  12. $mysql = new my_mysqli($host, $user, $passwd, $db, $port, $socket);
  13. $mysql->multi_query('SELECT 1;SELECT 2');
  14. do {
  15. $res = $mysql->store_result();
  16. if ($mysql->errno == 0) {
  17. while ($arr = $res->fetch_assoc()) {
  18. var_dump($arr);
  19. }
  20. $res->free();
  21. }
  22. } while ($mysql->next_result());
  23. var_dump($mysql->error, __LINE__);
  24. $mysql->close();
  25. $mysql = new my_mysqli($host, $user, $passwd, $db, $port, $socket);
  26. $mysql->multi_query('SELECT 1;SELECT 2');
  27. do {
  28. $res = $mysql->store_result();
  29. if ($mysql->errno == 0) {
  30. while ($arr = $res->fetch_assoc()) {
  31. var_dump($arr);
  32. }
  33. $res->free();
  34. }
  35. } while ($mysql->next_result());
  36. var_dump($mysql->error, __LINE__);
  37. ?>
  38. --EXPECTF--
  39. array(1) {
  40. [1]=>
  41. %s(1) "1"
  42. }
  43. array(1) {
  44. [2]=>
  45. %s(1) "2"
  46. }
  47. %s(0) ""
  48. int(%d)
  49. array(1) {
  50. [1]=>
  51. %s(1) "1"
  52. }
  53. array(1) {
  54. [2]=>
  55. %s(1) "2"
  56. }
  57. %s(0) ""
  58. int(%d)