bug79084_collision.phpt 1.2 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162
  1. --TEST--
  2. Bug #79084 (mysqlnd may fetch wrong column indexes with MYSQLI_BOTH) - collision
  3. --EXTENSIONS--
  4. mysqli
  5. --SKIPIF--
  6. <?php
  7. require_once('skipifconnectfailure.inc');
  8. ?>
  9. --FILE--
  10. <?php
  11. require_once('connect.inc');
  12. $sql = "SELECT 11111 as `1`, 22222 as `2`";
  13. // unbuffered
  14. $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket);
  15. $link->real_query($sql);
  16. $res = $link->use_result();
  17. $row = $res->fetch_array();
  18. var_dump($row);
  19. $link->close();
  20. // buffered
  21. ini_set('mysqlnd.fetch_data_copy', false);
  22. $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket);
  23. $res = $link->query($sql);
  24. $row = $res->fetch_array();
  25. var_dump($row);
  26. $link->close();
  27. // buffered copies
  28. ini_set('mysqlnd.fetch_data_copy', true);
  29. $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket);
  30. $res = $link->query($sql);
  31. $row = $res->fetch_array();
  32. var_dump($row);
  33. $link->close();
  34. ?>
  35. --EXPECT--
  36. array(3) {
  37. [0]=>
  38. string(5) "11111"
  39. [1]=>
  40. string(5) "11111"
  41. [2]=>
  42. string(5) "22222"
  43. }
  44. array(3) {
  45. [0]=>
  46. string(5) "11111"
  47. [1]=>
  48. string(5) "11111"
  49. [2]=>
  50. string(5) "22222"
  51. }
  52. array(3) {
  53. [0]=>
  54. string(5) "11111"
  55. [1]=>
  56. string(5) "11111"
  57. [2]=>
  58. string(5) "22222"
  59. }