0002080: mysql_fetch_assoc() doesn't obey column aliases

Viewing Issue Simple Details [ Jump to Notes ]

[ View Advanced ] [ Issue History ] [ Print ]

Category

Severity

Reproducibility

Date Submitted

Last Update

0002080

[Quercus]

minor

always

10-17-07 18:12

10-18-07 09:50

Reporter

koreth

View Status

public

Assigned To

ferg

Priority

normal

Resolution

fixed

Status

closed

Product Version

3.1.3

Summary

0002080: mysql_fetch_assoc() doesn't obey column aliases

Description

$res = mysql_query($conn, "SELECT foo AS bar FROM xyzzy");
$row = mysql_fetch_assoc($res);

In vanilla PHP, $row['bar'] will contain the value. In Quercus, $row['foo'] contains the value.

Additional Information

Patch:

--- a/modules/quercus/src/com/caucho/quercus/lib/db/JdbcResultResource.java
+++ b/modules/quercus/src/com/caucho/quercus/lib/db/JdbcResultResource.java
@@ -159,8 +159,12 @@ public class JdbcResultResource {
         if ((type & FETCH_ASSOC) != 0) {
           _columnNames = new Value[count];

- for (int i = 0; i < count; i++)
- _columnNames[i] = env.createString(_metaData.getColumnName(i + 1));
+ for (int i = 0; i < count; i++) {
+ String name = _metaData.getColumnLabel(i + 1);
+ if (name == null)
+ name = _metaData.getColumnName(i + 1);
+ _columnNames[i] = env.createString(name);
+ }
         }

         for (int i = 0; i < count; i++) {

Attached Files

Relationships

Notes
(0002362) ferg 10-18-07 09:50	php/141j

Issue History
Date Modified	Username	Field	Change
10-17-07 18:12	koreth	New Issue
10-18-07 09:50	ferg	Note Added: 0002362
10-18-07 09:50	ferg	Assigned To	=> ferg
10-18-07 09:50	ferg	Status	new => closed
10-18-07 09:50	ferg	Resolution	open => fixed
10-18-07 09:50	ferg	Fixed in Version	=> 3.1.4

Mantis 1.0.0rc3[^]

29 total queries executed.
26 unique queries executed.