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

Spider: [ERROR] Got error 12701 when reading table './test/t' on SELECT

Details

    Description

      INSTALL PLUGIN spider SONAME 'ha_spider.so';
      		 
      CREATE TABLE t (c INT KEY,c2 INT,KEY(c2)) ENGINE=SPIDER PARTITION BY LIST COLUMNS (c) (PARTITION p DEFAULT ENGINE=SPIDER);
      		 
      ALTER TABLE t ADD c2 BINARY FIRST;
      		 
      SELECT * FROM t WHERE c2='' AND c2='' AND c='' ORDER BY c2 DESC;

      Leads to an ERROR visible in the error log only:

      10.7.0 1bc82aaf0a7746c0921a94034aff2d51f0d75cd0 (Debug)

      		 
      2021-09-06 11:19:39 4 [ERROR] Got error 12701 when reading table './test/t'

      Furthermore, error 12701 is undefined:

      $ ./bin/perror 12701
      		 
      Illegal error code: 12701

      Bug confirmed present in:
      MariaDB: 10.4.22 (dbg), 10.4.22 (opt), 10.5.13 (dbg), 10.5.13 (opt), 10.6.5 (dbg), 10.6.5 (opt), 10.7.0 (dbg), 10.7.0 (opt)

      Bug (or feature/syntax) confirmed not present in:
      MariaDB: 10.2.41 (dbg), 10.2.41 (opt), 10.3.32 (dbg), 10.3.32 (opt)
      MySQL: 5.5.62 (dbg), 5.5.62 (opt), 5.6.51 (dbg), 5.6.51 (opt), 5.7.35 (dbg), 5.7.35 (opt), 8.0.26 (dbg), 8.0.26 (opt)

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-30576 Include spider error codes in extra/perror, especially 12719, 12701

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29455 mysql_ha_read attempts table read after 'Access denied' for server created by CREATE SERVER | Got error 12701 when reading table

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Activity

            People

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