php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #42589 getColumnMeta() should also return table name
Submitted: 2007-09-07 16:07 UTC Modified: 2009-01-13 02:51 UTC
Votes:2
Avg. Score:4.0 ± 1.0
Reproduced:1 of 1 (100.0%)
Same Version:0 (0.0%)
Same OS:0 (0.0%)
From: fabrizio dot balliano at crealabs dot it Assigned: scottmac (profile)
Status: Closed Package: PDO related
PHP Version: 5.2.4 OS: *
Private report: No CVE-ID: None
View Developer Edit
 [2007-09-07 16:07 UTC] fabrizio dot balliano at crealabs dot it 
Description:
------------
if you do 
"select * from table1 join table2 on (table1.id=table2.id)

how can you understand which fields are coming from table1 and which from table2?

the only way is that getcolumnmeta() also returns the table name of every column

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2007-10-13 09:59 UTC] mj@php.net 
I have suggested a first patch to implement this for MySQL and SQLite: http://news.php.net/php.internals/32742
 [2008-11-30 11:47 UTC] mj@php.net 
MySQL has been supporting this for quite some time now.  My patch for SQLite is still pending, I guess.
 [2009-01-08 10:40 UTC] pajoye@php.net 
Scott, can you take a look at the patch please?
 [2009-01-13 02:51 UTC] scottmac@php.net 
This bug has been fixed in CVS.

Snapshots of the sources are packaged every three hours; this change
will be in the next snapshot. You can grab the snapshot at
http://snaps.php.net/.
 
Thank you for the report, and for helping us make PHP better.

Will be in 5.3.0
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Fri Dec 27 16:01:29 2024 UTC