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

Assert failure when checking null value result for a row equality using a subquery

    XMLWordPrintable

    Details

      Description

      The following test case brings the server to an assert failure:

      create table t1 (a int) engine=myisam;
      insert into t1 values (3), (7), (1);
      create table t2 (b int) engine=myisam;
      insert into t2 values (1), (2), (3), (4);
      insert into t2 select * from t2;
      insert into t2 select * from t2;
      insert into t2 select * from t2;
      insert into t2 select * from t2;
      insert into t2 select * from t2;
      insert into t2 select * from t2;
      select * from t1 where ((select min(b), max(b) from t2 where b < 1) = (1, 2)) IS UNKNOWN;
      

      The assert failure occurs in the function Item::update_null_value ().

        Attachments

          Activity

            People

            Assignee:
            sanja Oleksandr Byelkin
            Reporter:
            igor Igor Babaev
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.