MySQL Defect : Can't retreive tablename in joined query
|Reported by:||bscott||Owned by:||danstoica|
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
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.
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, ...'.