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

SELECT from information schema fails when FederatedX loses underlying table

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.6, 10.11, 11.4, 11.8, 12.3
    • None
    • None

    Description

      INSTALL SONAME 'ha_federatedx';
       
      --eval create server fedlink foreign data wrapper mysql options (host "127.0.0.1", database "test", user "root", port $MASTER_MYPORT)
       
      CREATE TABLE t AS SELECT 1 AS a;
      CREATE TABLE fed_t (a INT) ENGINE=FEDERATED CONNECTION = 'fedlink/t';
       
      SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'test';
      DROP TABLE t;
      SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'test';
       
      DROP TABLE fed_t;
      DROP SERVER fedlink;
      UNINSTALL SONAME 'ha_federatedx';
      

      main 685e0f8170a6da1c35e110c9016e8fa7859e6c54

      mysqltest: At line 10: query 'SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'test'' failed: ER_NO_SUCH_TABLE (1146): Received error: 1146 : Remote table does not exist
      

      The problem is not only that the query fails as such, but also that it doesn't say which table is guilty, so there is no easy way to fix the problem.

      The error is specific to FederatedX, with Federated the query from I_S works.

      Attachments

        Issue Links

          Activity

            People

              serg Sergei Golubchik
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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