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

Got error 128 when reading table on SELECT

    XMLWordPrintable

Details

    Description

      --source plugin/spider/spider/include/init_spider.inc
      SET spider_same_server_link=on;
      eval CREATE SERVER srv FOREIGN DATA WRAPPER MYSQL OPTIONS (HOST "127.0.0.1", DATABASE "test", USER "root", PORT $MASTER_MYPORT);
      CREATE TABLE t (c INT KEY,c1 INT,c2 INT);
      INSERT INTO t VALUES (0,1,0),(1,0,0),(2,0,0);
      CREATE TABLE t1 (c1 INT,c2 INT,c3 INT,PRIMARY KEY(c1),UNIQUE INDEX (c2)) ENGINE=Spider COMMENT='WRAPPER "mysql",SRV "srv",TABLE "t"';
      --error ER_BAD_FIELD_ERROR
      SELECT * FROM t1 WHERE c1='' OR c2='' HAVING COUNT(*)=1;
      

      Leads to:

      CS 11.2.6 e91a79945822def1452787f825e6047c6a64dbd9 (Debug)

      [ERROR] Got error 128 when reading table './test/t1'
      

      In the error log (see var/log/mysqld.1.err after MTR replay)

      Attachments

        Activity

          People

            ycp Yuchen Pei
            Roel Roel Van de Paar
            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.