Opened 15 years ago

Last modified 14 years ago

#228 new defect

MySQL Defect : Can't retreive tablename in joined query

Reported by: bscott Owned by: danstoica
Priority: major Milestone: 3.4.0
Component: MySQL Provider Version: 3.2.0
Severity: 4 Keywords:
Cc: External ID:

Description

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

Change History (2)

comment:1 by gregboone, 15 years ago

Owner: changed from gregboone to danstoica

comment:2 by gregboone, 14 years ago

Milestone: 3.3.03.3.1
Note: See TracTickets for help on using tickets.