bug_79106.phpt 974 B

123456789101112131415161718192021222324252627282930313233343536373839404142434445
  1. --TEST--
  2. Bug #79106 (PDO may fetch wrong column indexes with PDO::FETCH_BOTH)
  3. --EXTENSIONS--
  4. pdo
  5. --SKIPIF--
  6. <?php
  7. $dir = getenv('REDIR_TEST_DIR');
  8. if (!$dir) die('skip no driver');
  9. require_once $dir . 'pdo_test.inc';
  10. try {
  11. $db = PDOTest::factory();
  12. } catch (PDOException $e) {
  13. die('skip ' . $e->getMessage());
  14. }
  15. if (@$db->query('SELECT 1 as "1"') === false) {
  16. die('skip driver does not support quoted numeric identifiers');
  17. }
  18. ?>
  19. --FILE--
  20. <?php
  21. if (getenv('REDIR_TEST_DIR') === false) putenv('REDIR_TEST_DIR=' . dirname(__FILE__) . '/../../pdo/tests/');
  22. require_once getenv('REDIR_TEST_DIR') . 'pdo_test.inc';
  23. $db = PDOTest::factory();
  24. $stmt = $db->query('SELECT 0 as "2007", 0 as "2008", 0 as "2020"');
  25. var_dump($stmt->fetchAll());
  26. ?>
  27. --EXPECT--
  28. array(1) {
  29. [0]=>
  30. array(6) {
  31. [2007]=>
  32. string(1) "0"
  33. [0]=>
  34. string(1) "0"
  35. [2008]=>
  36. string(1) "0"
  37. [1]=>
  38. string(1) "0"
  39. [2020]=>
  40. string(1) "0"
  41. [2]=>
  42. string(1) "0"
  43. }
  44. }