ID: 46533 Updated by: [EMAIL PROTECTED] Reported By: taco at procurios dot nl -Status: Open +Status: Assigned Bug Type: PDO related Operating System: Linux PHP Version: 5.2.6 -Assigned To: +Assigned To: mysql
Previous Comments: ------------------------------------------------------------------------ [2008-11-10 10:09:12] taco at procurios dot nl Description: ------------ When using aliases for tables and/or columns in a MySQL query. The method PDOStatement::getColumnMeta() will not tell you anything about the original table / column name. In the MySQLi extension the information about the original table / column name was represented as 'orgtable' and 'orgname' this would be a very nice addition to the PDO extension. Reproduce code: --------------- SQL: CREATE TABLE `foobar` ( `bar` varchar(255) default NULL ) ENGINE=MEMORY; PHP: print_r( $PDO->query("SELECT foo.bar as baz FROM foobar foo") ->getColumnMeta(0) ); Expected result: ---------------- Array ( [native_type] => VAR_STRING [flags] => Array ( ) [table] => foo [orgtable] => foobar [name] => baz [orgname] => bar [len] => 255 [precision] => 0 [pdo_type] => 2 ) Actual result: -------------- Array ( [native_type] => VAR_STRING [flags] => Array ( ) [table] => foo [name] => baz [len] => 255 [precision] => 0 [pdo_type] => 2 ) ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=46533&edit=1