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

Memory leak on running query in PS mode with condition that has 'ANY/SOME (subquery)' clause and any kind of the following comparisons '>', '>=', '<', '<=' '

    XMLWordPrintable

Details

    Description

      The following test cases executed with --ps-protocol fail with assert on server built in debug mode with -DWITH_PROTECT_STATEMENT_MEMROOT

      CREATE TABLE t1 (s1 CHAR(1));
      INSERT INTO t1 VALUES ('a');
      SELECT * FROM t1 WHERE _utf8'a' > ANY (SELECT s1 FROM t1);
      DROP TABLE t1;
      

      CREATE TABLE t1 (f1 CHAR(3) CHARACTER SET utf8 NULL, f2 CHAR(3) CHARACTER SET latin1 NULL);
      INSERT INTO t1 VALUES ('foo','bar');
      SELECT * FROM t1 WHERE f2 >= SOME ( SELECT f1 FROM t1 );
      DROP TABLE t1;
      

      In case the condition of the query is changed to '=' the above mentioned tests cases be completed without assert failures.

      Attachments

        Issue Links

          Activity

            People

              shulga Dmitry Shulga
              shulga Dmitry Shulga
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.