Bug #77066 [NEW]: PDO_INFORMIX generate a empty column name for expressions

From: as at nsi dot de Operating system: All PHP version: 7.0.32 Package: PDO related Bug Type: Bug Bug description:PDO_INFORMIX generate a empty column name for expressions Description: ------------ When I write a Statement: select 'a', tabname, 'b' from systables; I execute the the statement with ..->query() and fetch with PDO::FETCH_ASSOC, then the first and the third column has as name '' and the third column overwrites the first in the resulting row-array. Test script: --------------- <?PHP $db = new PDO("informix:host=<hostname>; service=<port>; database=sysmaster; server=<INFORMIXSERVER>; protocol=onsoctcp; EnableScrollableCursors=1", "informix", "<userpassword>"); $stmt = $db->query("select 'a', tabname, 'b' from systables"); $i = 1; while ($row = $stmt->fetch(PDO::FETCH_ASSOC) ) { print_r($row); if ( $i++ > 4 ) break; } ?> Expected result: ---------------- The expression columns must be named unique by example expr1, expr2, ... expr<n>. Actual result: -------------- Array ( [] => b [TABNAME] => systables ) Array ( [] => b [TABNAME] => syscolumns ) Array ( [] => b [TABNAME] => sysindices ) Array ( [] => b [TABNAME] => systabauth ) Array ( [] => b [TABNAME] => syscolauth ) -- Edit bug report at https://bugs.php.net/bug.php?id=77066&edit=1 -- Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=77066&r=trysnapshot54 Try a snapshot (PHP 5.5): https://bugs.php.net/fix.php?id=77066&r=trysnapshot55 Try a snapshot (trunk): https://bugs.php.net/fix.php?id=77066&r=trysnapshottrunk Fixed in SVN: https://bugs.php.net/fix.php?id=77066&r=fixed Fixed in release: https://bugs.php.net/fix.php?id=77066&r=alreadyfixed Need backtrace: https://bugs.php.net/fix.php?id=77066&r=needtrace Need Reproduce Script: https://bugs.php.net/fix.php?id=77066&r=needscript Try newer version: https://bugs.php.net/fix.php?id=77066&r=oldversion Not developer issue: https://bugs.php.net/fix.php?id=77066&r=support Expected behavior: https://bugs.php.net/fix.php?id=77066&r=notwrong Not enough info: https://bugs.php.net/fix.php?id=77066&r=notenoughinfo Submitted twice: https://bugs.php.net/fix.php?id=77066&r=submittedtwice register_globals: https://bugs.php.net/fix.php?id=77066&r=globals PHP 4 support discontinued: https://bugs.php.net/fix.php?id=77066&r=php4 Daylight Savings: https://bugs.php.net/fix.php?id=77066&r=dst IIS Stability: https://bugs.php.net/fix.php?id=77066&r=isapi Install GNU Sed: https://bugs.php.net/fix.php?id=77066&r=gnused Floating point limitations: https://bugs.php.net/fix.php?id=77066&r=float No Zend Extensions: https://bugs.php.net/fix.php?id=77066&r=nozend MySQL Configuration Error: https://bugs.php.net/fix.php?id=77066&r=mysqlcfg