From: mattsch at gmail dot com Operating system: Gentoo Linux PHP version: 5.2.4 PHP Bug Type: PDO related Bug description: PDO fetch doesn't preserve case
Description: ------------ PDO fetch doesn't preserve the case of the column. I don't know if this is a "feature" or if it is a bug, but if it is a "feature" since the beginning of PDO, could I also suggest that another flag be added for PDO fetch to tell it to preserve the case? Reproduce code: --------------- <?php try { $pdo = new PDO("pgsql:host={$host};dbname={$database}", $user, $password); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $pdo->query("SET search_path to {$schema}"); $accountState = $pdo->prepare(' SELECT id AS accountId FROM account WHERE id = ? '); $accountState->bindParam(1, $id, PDO::PARAM_INT); $accountState->execute(); $getAccount = $accountState->fetch(PDO::FETCH_OBJ); $accountState->closeCursor(); var_dump($getAccount); } catch (Exception $e){ print "An error occurred: {$e->getMessage()}"; } ?> Expected result: ---------------- object(stdClass)#8 (1) { ["accountId"]=> int(339) } Actual result: -------------- object(stdClass)#8 (1) { ["accountid"]=> int(339) } -- Edit bug report at http://bugs.php.net/?id=42632&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=42632&r=trysnapshot44 Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=42632&r=trysnapshot52 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=42632&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=42632&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=42632&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=42632&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=42632&r=needscript Try newer version: http://bugs.php.net/fix.php?id=42632&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=42632&r=support Expected behavior: http://bugs.php.net/fix.php?id=42632&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=42632&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=42632&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=42632&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=42632&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=42632&r=dst IIS Stability: http://bugs.php.net/fix.php?id=42632&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=42632&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=42632&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=42632&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=42632&r=mysqlcfg