bug45458.phpt 1.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081
  1. --TEST--
  2. Bug #45458 (OCI8: Numeric keys for associative arrays are not handled properly)
  3. --EXTENSIONS--
  4. oci8
  5. --FILE--
  6. <?php
  7. require(__DIR__.'/connect.inc');
  8. // Run Test
  9. echo "Test 1\n";
  10. $stmt = 'select dummy "A", dummy "20" from dual';
  11. $s = oci_parse($c, $stmt);
  12. oci_execute($s);
  13. $r = oci_fetch_all($s, $data, 0, -1, OCI_FETCHSTATEMENT_BY_ROW);
  14. var_dump($data);
  15. var_dump($data[0]);
  16. var_dump($data[0]["A"]);
  17. var_dump($data[0]["20"]);
  18. oci_free_statement($s);
  19. echo "Test 2\n";
  20. $s = oci_parse($c, $stmt);
  21. oci_execute($s);
  22. $r = oci_fetch_all($s, $data, 0, -1, OCI_ASSOC);
  23. var_dump($data);
  24. var_dump($data["A"]);
  25. var_dump($data["20"]);
  26. var_dump($data["A"][0]);
  27. var_dump($data["20"][0]);
  28. oci_free_statement($s);
  29. oci_close($c);
  30. ?>
  31. --EXPECT--
  32. Test 1
  33. array(1) {
  34. [0]=>
  35. array(2) {
  36. ["A"]=>
  37. string(1) "X"
  38. [20]=>
  39. string(1) "X"
  40. }
  41. }
  42. array(2) {
  43. ["A"]=>
  44. string(1) "X"
  45. [20]=>
  46. string(1) "X"
  47. }
  48. string(1) "X"
  49. string(1) "X"
  50. Test 2
  51. array(2) {
  52. ["A"]=>
  53. array(1) {
  54. [0]=>
  55. string(1) "X"
  56. }
  57. [20]=>
  58. array(1) {
  59. [0]=>
  60. string(1) "X"
  61. }
  62. }
  63. array(1) {
  64. [0]=>
  65. string(1) "X"
  66. }
  67. array(1) {
  68. [0]=>
  69. string(1) "X"
  70. }
  71. string(1) "X"
  72. string(1) "X"