ID: 50147 Updated by: u...@php.net Reported By: w at lder dot de -Status: Open +Status: Feedback Bug Type: MySQL related Operating System: Linux 2.6.16.21-0.25-default PHP Version: 5.2.11 New Comment:
ext/mysql returns whatever MySQL delivers. Please verify that the MySQL prompt returns the result you want. If not, this is a MySQL bug not a PHP bug. Please run on the command line: mysql -u<user> -p<password> <database>... mysql> SHOW COLUMNS FROM <mytable> Previous Comments: ------------------------------------------------------------------------ [2009-11-11 10:35:02] w at lder dot de Description: ------------ The attached Code results a wrong result. MySQL: Server Version: 5.0.26 MySQL-Client-Version: 5.0.26 Reproduce code: --------------- <?php /* MySQL: CREATE TABLE IF NOT EXISTS `test` ( `hereIsDefaultNULL` int(255) default NULL, `defaultNULLvarchar` varchar(255) default NULL ) */ mysql_connect('localhost','user',''); mysql_select_db('test'); $columns_res = mysql_query('SHOW COLUMNS FROM `test`'); while ($fieldRow = mysql_fetch_assoc($columns_res)) { print_r($fieldRow) ; } ?> Expected result: ---------------- Array ( [Field] => hereIsDefaultNULL [Type] => int(255) [Null] => YES [Key] => [Default] => NULL [Extra] => ) Array ( [Field] => defaultNULLvarchar [Type] => varchar(255) [Null] => YES [Key] => [Default] => NULL [Extra] => ) Actual result: -------------- Array ( [Field] => hereIsDefaultNULL [Type] => int(255) [Null] => YES [Key] => [Default] => [Extra] => ) Array ( [Field] => defaultNULLvarchar [Type] => varchar(255) [Null] => YES [Key] => [Default] => [Extra] => ) ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=50147&edit=1