#46533 [NEW]: PDOStatement::getColumnMeta lacks some information regarding aliases

From: taco at procurios dot nl Operating system: Linux PHP version: 5.2.6 PHP Bug Type: PDO related Bug description: PDOStatement::getColumnMeta lacks some information regarding aliases 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 bug report at http://bugs.php.net/?id=46533&edit=1 -- Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=46533&r=trysnapshot52 Try a CVS snapshot (PHP 5.3): http://bugs.php.net/fix.php?id=46533&r=trysnapshot53 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=46533&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=46533&r=fixedcvs Fixed in CVS and need be documented: http://bugs.php.net/fix.php?id=46533&r=needdocs Fixed in release: http://bugs.php.net/fix.php?id=46533&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=46533&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=46533&r=needscript Try newer version: http://bugs.php.net/fix.php?id=46533&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=46533&r=support Expected behavior: http://bugs.php.net/fix.php?id=46533&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=46533&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=46533&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=46533&r=globals PHP 4 support discontinued: http://bugs.php.net/fix.php?id=46533&r=php4 Daylight Savings: http://bugs.php.net/fix.php?id=46533&r=dst IIS Stability: http://bugs.php.net/fix.php?id=46533&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=46533&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=46533&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=46533&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=46533&r=mysqlcfg