Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.5.8, 10.4(EOL), 10.6
-
Debian Buster x86
Description
Hi using spider as federated tables each table on same backend
MariaDB [SANDBOX]> SELECT * from TEST_RDT_2 JOIN TEST_RDT_3 ON TEST_RDT_2.ID = TEST_RDT_3.ID LEFT OUTER JOIN TEST_RDT_1 ON TEST_RDT_1.ID = TEST_RDT_2.ID; |
ERROR 1054 (42S22): Unknown column 't0.ID' in 'on clause' |
MariaDB [SANDBOX]> SELECT * from TEST_RDT_2 LEFT OUTER JOIN TEST_RDT_1 ON TEST_RDT_1.ID = TEST_RDT_2.ID JOIN TEST_RDT_3 ON TEST_RDT_2.ID = TEST_RDT_3.ID ; |
+----+-----------+------+-----------+----+---------+ |
| ID | LASTNAME | ID | FIRSTNAME | ID | SURNAME |
|
+----+-----------+------+-----------+----+---------+ |
| 1 | DEMONGEOT | 1 | RICHARD | 1 | CON |
|
| 2 | VAROQUI | 2 | STEPHANE | 2 | MOYEN |
|
+----+-----------+------+-----------+----+---------+ |
2 rows in set (0.008 sec) |
Depending on the pos of LEFT join in FROM clause it failed or not .