#47832 [NEW]: Garbled associative array indices

From:             r dot borschel at gmx dot net
Operating system: OS X 10.5.6
PHP version:      5.3CVS-2009-03-29 (snap)
PHP Bug Type:     PDO related
Bug description:  Garbled associative array indices

Description:
------------
Associative array indices are getting garbled when usind pdo_mysql when
mysql & pdo_mysql were compiled against libmysql. Compiling against mysqlnd
fixes the issue.

Reproduce code:
---------------
#
# SQL
#

CREATE TABLE IF NOT EXISTS `cms_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `status` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `doctrinetests`.`cms_users` (
`id` ,
`status` ,
`username` ,
`name`
) VALUES (NULL , 'developer', 'romanb', 'Roman');

#
# PHP
#
$pdo = new PDO("mysql:host=localhost;dbname=testdb", "xxx", "xxx");

$stmt = $pdo->prepare("SELECT c0.id AS c0__id, c0.status AS c0__status,
c0.username AS c0__username, c0.name AS c0__name FROM cms_users c0");

$stmt->execute();

while ($data = $stmt->fetch(PDO::FETCH_ASSOC)) {
    var_dump($data);
}

Expected result:
----------------
array(6) {
  ["c0__id"]=>  string(2) "16"
  ["c0__status"]=>  string(9) "developer"
  ["c0__username"]=>  string(6) "romanb"
  ["c0__name"]=>  string(5) "Roman"
}  

Actual result:
--------------
array(6) {
  ["c0__id"]=>  string(2) "16"
  ["status"]=>  string(9) "developer"
  ["c0"]=>  string(6) "romanb"
  ["cms_users"]=>  string(5) "Roman"
}  

-- 
Edit bug report at http://bugs.php.net/?id=47832&edit=1
-- 
Try a CVS snapshot (PHP 5.2):        http://bugs.php.net/fix.php?id=47832&r=trysnapshot52
Try a CVS snapshot (PHP 5.3):        http://bugs.php.net/fix.php?id=47832&r=trysnapshot53
Try a CVS snapshot (PHP 6.0):        http://bugs.php.net/fix.php?id=47832&r=trysnapshot60
Fixed in CVS:                        http://bugs.php.net/fix.php?id=47832&r=fixedcvs
Fixed in CVS and need be documented: http://bugs.php.net/fix.php?id=47832&r=needdocs
Fixed in release:                    http://bugs.php.net/fix.php?id=47832&r=alreadyfixed
Need backtrace:                      http://bugs.php.net/fix.php?id=47832&r=needtrace
Need Reproduce Script:               http://bugs.php.net/fix.php?id=47832&r=needscript
Try newer version:                   http://bugs.php.net/fix.php?id=47832&r=oldversion
Not developer issue:                 http://bugs.php.net/fix.php?id=47832&r=support
Expected behavior:                   http://bugs.php.net/fix.php?id=47832&r=notwrong
Not enough info:                     http://bugs.php.net/fix.php?id=47832&r=notenoughinfo
Submitted twice:                     http://bugs.php.net/fix.php?id=47832&r=submittedtwice
register_globals:                    http://bugs.php.net/fix.php?id=47832&r=globals
PHP 4 support discontinued:          http://bugs.php.net/fix.php?id=47832&r=php4
Daylight Savings:                    http://bugs.php.net/fix.php?id=47832&r=dst
IIS Stability:                       http://bugs.php.net/fix.php?id=47832&r=isapi
Install GNU Sed:                     http://bugs.php.net/fix.php?id=47832&r=gnused
Floating point limitations:          http://bugs.php.net/fix.php?id=47832&r=float
No Zend Extensions:                  http://bugs.php.net/fix.php?id=47832&r=nozend
MySQL Configuration Error:           http://bugs.php.net/fix.php?id=47832&r=mysqlcfg