pecl_bug_5200.phpt 1018 B

123456789101112131415161718192021222324252627282930313233343536
  1. --TEST--
  2. PDO MySQL PECL Bug #5200 (Describe table gives unexpected result mysql and type enum)
  3. --SKIPIF--
  4. <?php
  5. if (!extension_loaded('pdo') || !extension_loaded('pdo_mysql')) die('skip not loaded');
  6. require dirname(__FILE__) . '/config.inc';
  7. require dirname(__FILE__) . '/../../../ext/pdo/tests/pdo_test.inc';
  8. PDOTest::skip();
  9. ?>
  10. --FILE--
  11. <?php
  12. require dirname(__FILE__) . '/../../../ext/pdo/tests/pdo_test.inc';
  13. $db = PDOTest::test_factory(dirname(__FILE__). '/common.phpt');
  14. $db->exec("CREATE TABLE test (bar INT NOT NULL, phase enum('please_select', 'I', 'II', 'IIa', 'IIb', 'III', 'IV'))");
  15. foreach ($db->query('DESCRIBE test phase')->fetchAll(PDO::FETCH_ASSOC) as $row) {
  16. print_r($row);
  17. }
  18. ?>
  19. --CLEAN--
  20. <?php
  21. require dirname(__FILE__) . '/mysql_pdo_test.inc';
  22. $db = MySQLPDOTest::factory();
  23. $db->exec('DROP TABLE IF EXISTS test');
  24. ?>
  25. --EXPECT--
  26. Array
  27. (
  28. [field] => phase
  29. [type] => enum('please_select','I','II','IIa','IIb','III','IV')
  30. [null] => YES
  31. [key] =>
  32. [default] =>
  33. [extra] =>
  34. )