0003202: Mysql PDO fetch bug

Viewing Issue Advanced Details [ Jump to Notes ]

[ View Simple ] [ Issue History ] [ Print ]

Category

Severity

Reproducibility

Date Submitted

Last Update

0003202

[Quercus]

minor

always

12-29-08 11:32

07-18-23 02:09

Reporter

lzymll

View Status

public

Assigned To

Priority

normal

Resolution

open

Platform

Status

new

Projection

none

OS Version

ETA

none

Fixed in Version

Product Version

3.1.8

Product Build

Summary

0003202: Mysql PDO fetch bug

Description

when query "select id,majorname as name from category"

$array = $PDO->fetch(PDO::fetch_assoc)

can't find $array["name"], still is original table column name. and column name case won't change.

Steps To Reproduce

Additional Information

Attached Files

Relationships

Notes
(0003684) lzymll 12-29-08 16:11	Fixed,Using MySQL Connector/J 5.0 MySQL Connector/J 5.1 is not working

(0005099) jamesdlow 03-01-11 19:55	Using 5.0 fixed it for me. I remember having this problem even when just using JDBC from within Java with some versions of MySQL connector.

(0005100) jamesdlow 03-01-11 20:11	This link shows what changed between 5.0 and 5.1: http://bugs.mysql.com/bug.php?id=48947 [^] It seems that getColumnName / getColumnLabel return different things in 5.1 and com.caucho.quercus.lib.db.PDOStatement seems to use getColumnName. Maybe it should be changed to use getColumnLabel? This is what I've done in my Java only projects in the past.

Issue History
Date Modified	Username	Field	Change
12-29-08 11:32	lzymll	New Issue
12-29-08 16:11	lzymll	Note Added: 0003684
02-28-11 07:30	jamesdlow	Issue Monitored: jamesdlow
03-01-11 19:55	jamesdlow	Note Added: 0005099
03-01-11 20:11	jamesdlow	Note Added: 0005100
03-02-11 02:01	kdecherf	Issue Monitored: kdecherf
07-18-23 02:09	WilliamThompson	Note Added: 0007217
11-14-23 17:33	ferg	Note Deleted: 0007217

Mantis 1.0.0rc3[^]

40 total queries executed.
31 unique queries executed.