MySQL Defect : Can't retreive tablename in joined query

[bscott]

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, ...'.