#48724 [Opn]: getColumnMeta() doesn't return native_type for BIT, TINYINT and YEAR

 ID:               48724
 Updated by:       [email protected]
 Reported By:      an0nym at narod dot ru
 Status:           Open
 Bug Type:         PDO related
 Operating System: *
 PHP Version:      5.3.0
 New Comment:

Warning

This function is EXPERIMENTAL. The behaviour of this function, its
name, and surrounding documentation may change without notice in a
future release of PHP. This function should be used at your own risk. 

http://de2.php.net/manual/en/pdostatement.getcolumnmeta.php

How can there be a bug if behaviour is undefined?


Previous Comments:
------------------------------------------------------------------------

[2009-06-30 15:33:29] an0nym at narod dot ru

Tested - this bug remains actual with PHP 5.3.0 and mysqlnd.

------------------------------------------------------------------------

[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