Opened 14 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 Changed 14 years ago by gregboone

Owner: changed from gregboone to danstoica

comment:2 Changed 14 years ago by gregboone

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