php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
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
 [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

Add a Patch

Pull Requests

Add a Pull Request

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-2019 The PHP Group
All rights reserved.
Last updated: Tue Jun 25 00:01:26 2019 UTC