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