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 .
Attachments
Activity
It doesn't seem to affect the other queries as much as I had initially expected.
holyfoot Please review https://github.com/MariaDB/server/commit/33a058593f5c76f0a30c79ad7f1d7f7be83f18ea
holyfoot The fix has been proposed months ago. Please review.
The following patch fixes the bug but this must affect other queries. So, I need to dig the problem further.
diff --git a/storage/spider/spd_db_mysql.cc b/storage/spider/spd_db_mysql.ccindex ee3c25d914c..b0f868110fd 100644--- a/storage/spider/spd_db_mysql.cc+++ b/storage/spider/spd_db_mysql.cc{{DBUG_RETURN(HA_ERR_OUT_OF_MEM);}- str->q_append(SPIDER_SQL_COMMA_STR, SPIDER_SQL_COMMA_LEN);+ str->q_append(SPIDER_SQL_JOIN_STR, SPIDER_SQL_JOIN_LEN);}}}