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

Bogus ER_OUT_OF_RESOURCES upon LEFT JOIN from spider and non-spider table

    XMLWordPrintable

Details

    • Bug
    • Status: Stalled (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
    • 10.5, 10.6
    • None

    Description

      --source plugin/spider/spider/include/init_spider.inc
       
      SET spider_same_server_link= on;
      eval create server s foreign data wrapper mysql options (host "127.0.0.1", database "test", user "root", port $MASTER_MYPORT);
       
      CREATE TABLE t1 (a int) ENGINE=MyISAM;
      CREATE TABLE t2 (b int) ENGINE=MyISAM;
      CREATE TABLE t1_spider (a int) ENGINE=SPIDER COMMENT = "wrapper 'mysql', srv 's', table 't1'";
       
      SELECT * FROM t1_spider LEFT JOIN t2 ON a = b WHERE b = 3 OR a = 4;
       
      # Cleanup
       
      DROP TABLE t1_spider, t1, t2;
      DROP SERVER s;
       
      --source plugin/spider/spider/include/deinit_spider.inc
      

      10.3 ce23802c

      mysqltest: At line 10: query 'SELECT * FROM t1_spider LEFT JOIN t2 ON a = b WHERE b = 3 OR a = 4' failed: 1041: Out of memory.
      

      Reproducible on all of 10.3-10.10, with MyISAM or Aria for the joining table.

      Attachments

        Activity

          People

            ycp Yuchen Pei
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            5 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.