Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
2.0.15
-
None
-
None
-
Windows 10
Description
*SQL: *
SELECT d., g.
FROM device AS d
INNER JOIN group_assign AS ass ON ass.device_id = d.id
INNER JOIN group AS g ON ass.group_id = g.id;
I get the wrong BaseTableName for the first column. In this case i get for the d.id the BaseTableName "group" and if I change the order "SELECT g., d. FROM ..." I get the BaseTableName "device" for the first column g.id.
Workaround:
*SQL: *
SELECT d.id AS dummy, d., g.
FROM device AS d
INNER JOIN group_assign AS ass ON ass.device_id = d.id
INNER JOIN group AS g ON ass.group_id = g.id;
Now I get for column "dummy" the BaseTableName "group" (see attachment). I guess the first colmun in result always returns the BaseTableName of the second table of the select statement?!
I tested it with the MySQL ODBC 5.2 driver and the newest MySQL ADO.NET driver and in it works fine in both cases.