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

ERROR 12702 (HY000): Remote table 'test.t#P#p' is not found on INSERT when using partitioning with invalid credentials or invalid socket

    XMLWordPrintable

Details

    Description

      INSTALL PLUGIN Spider SONAME 'ha_spider.so';
      CREATE TABLE t (c INT) ENGINE=Spider COMMENT='wrapper "mysql", SOCKET "../socket.sock", user "", database "test"' PARTITION BY RANGE (c) (PARTITION p VALUES LESS THAN (10));
      INSERT INTO t VALUES (1);
      

      Leads to:

      10.5.26 b8f92ade57691a78cc97c5d79eae0a27a10cb8f2 (Optimized)

      10.5.26-opt>INSERT INTO t VALUES (1);
      ERROR 12702 (HY000): Remote table 'test.t#P#p' is not found
      

      11.6.0 d83742622dd1bece3f6a3a11ac0be64de0f3ff84 (Debug)

      11.6.0-dbg>INSERT INTO t VALUES (1);
      ERROR 12702 (HY000): Remote table 'test.t#P#p' is not found
      

      On ES, this works correctly:

      ES 11.4.2 97f04821b26e5d6660c1a6401996b8eec51b131c (Debug)

      11.4.2-dbg>INSERT INTO t VALUES (1);
      ERROR 1429 (HY000): Unable to connect to foreign data source: localhost
      

      Attachments

        Issue Links

          Activity

            People

              ycp Yuchen Pei
              Roel Roel Van de Paar
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.