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

SELECT using ror_merged scan fails with s3 tables

    XMLWordPrintable

Details

    • Unexpected results
    • SELECT using ror_merged (multi-index) scan could fail with s3 tables with error "Out of memory".

    Description

      Run with S3 options.

      DROP TABLE IF EXISTS t;
      CREATE TABLE t (a INT, b INT, KEY(a), KEY(b)) ENGINE=Aria;
      INSERT INTO t VALUES (0,0),(0,10),(3,10);
      ALTER TABLE t ENGINE=S3;
      SELECT * FROM t WHERE a = 99 OR b = 2;
      DROP TABLE t;
      

      10.5 8494758e

      mysqltest: At line 5: query 'SELECT * FROM t WHERE a = 99 OR b = 2' failed: 1041: Out of memory.
      

      error log

      2022-07-23  1:11:09 4 [ERROR] Got error 128 when reading table './test/t'
      

      Reproducible on 10.5+, with MinIO and AWS alike.

      Attachments

        Activity

          People

            monty Michael Widenius
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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