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 .
Bug
Major
