1--TEST-- 2PDO MySQL PECL Bug #5200 (Describe table gives unexpected result mysql and type enum) 3--EXTENSIONS-- 4pdo_mysql 5--SKIPIF-- 6<?php 7require_once __DIR__ . '/inc/mysql_pdo_test.inc'; 8MySQLPDOTest::skip(); 9?> 10--FILE-- 11<?php 12require_once __DIR__ . '/inc/mysql_pdo_test.inc'; 13$db = MySQLPDOTest::factory(); 14 15$db->exec("CREATE TABLE test_pecl_bug_5200 (bar INT NOT NULL, phase enum('please_select', 'I', 'II', 'IIa', 'IIb', 'III', 'IV'))"); 16 17foreach ($db->query('DESCRIBE test_pecl_bug_5200 phase')->fetchAll(PDO::FETCH_ASSOC) as $row) { 18 print_r($row); 19} 20?> 21--CLEAN-- 22<?php 23require_once __DIR__ . '/inc/mysql_pdo_test.inc'; 24$db = MySQLPDOTest::factory(); 25$db->exec('DROP TABLE IF EXISTS test_pecl_bug_5200'); 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