[fdo-trac] #228: MySQL Defect : Can't retreive tablename in joined query

[FDO]

#228: MySQL Defect : Can't retreive tablename in joined query
------------------------------+---------------------------------------------
   Reporter:  bscott          |       Owner:  gregboone
       Type:  defect          |      Status:  new      
   Priority:  major           |   Milestone:  3.3.0    
  Component:  MySQL Provider  |     Version:  3.2.0    
   Severity:  4               |    Keywords:           
External_id:                  |  
------------------------------+---------------------------------------------
 I use FdoISQLCommand to execute joined query in fdo provider that support
 SQLCommand.
 Typical query:
   Select table1.column1,table2.column1 from table1,table2 where table1.key
 = table2.key

 In FdoMySQL the query execute properly but when a retreive the result
 using
   FdoISQLDataReader::GetColumnName(index)
 i only get the column name without the tablename
 So there are no ways to distinguish between table1.column1 and
 table2.column1
 because GetColumnName only return column1.

 either GetColumnName should return tableName.columnName
 or a new function GetTableName should be implemented

 Orest Comment:
 You could go ahead a create a ticket for this one as well and we can
 consider an approach around GetColumnName. A GetTableName approach may not
 always make sense in all cases. E.g. 'select table1.column1 +
 table2.column2 from table1, table2, ...'.

-- 
Ticket URL: <http://trac.osgeo.org/fdo/ticket/228>
FDO <http://fdo.osgeo.org/>
Feature Data Objects