Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-24343

Spider Left join failed Unknown column 't0.ID' in 'on clause'

    XMLWordPrintable

Details

    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

        1. variables_spider.txt
          22 kB
        2. TEST_RDT_3.sql
          2 kB
        3. TEST_RDT_2.sql
          2 kB
        4. TEST_RDT_1.sql
          2 kB

        Activity

          People

            nayuta-yanagisawa Nayuta Yanagisawa (Inactive)
            stephane@skysql.com VAROQUI Stephane
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.