ID: 48724 User updated by: an0nym at narod dot ru Reported By: an0nym at narod dot ru Status: Open Bug Type: PDO related Operating System: * -PHP Version: 5.2.10 +PHP Version: 5.3.0 New Comment:
Tested - this bug remains actual with PHP 5.3.0 and mysqlnd. Previous Comments: ------------------------------------------------------------------------ [2009-06-29 18:02:58] an0nym at narod dot ru Description: ------------ PDOStatement::getColumnMeta() doesn't return native_type for BIT, TINYINT and YEAR type columns (these should be 'BIT', 'TINY' and 'YEAR' respectively). This bug was partly discussed within bug #46533, but that bug is generally about another thing. Reproduce code: --------------- $DB=new PDO('mysql:host=localhost;dbname=test','anyone','anyone'); $DB->exec('CREATE TABLE `test`( `bit` bit(1) ,`tinyint` tinyint ,`year` year)'); $DB->exec('INSERT INTO `test` VALUES(1,1,2000)'); $statement=$DB->query('SELECT `bit`,`tinyint`,`year` FROM `test`'); $bit=$statement->getColumnMeta(0); $tinyint=$statement->getColumnMeta(1); $year=$statement->getColumnMeta(2); var_dump(isset($bit['native_type']),isset($tinyint['native_type']),isset($year['native_type'])); Expected result: ---------------- bool(true) bool(true) bool(true) Actual result: -------------- bool(false) bool(false) bool(false) ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=48724&edit=1