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

Server crashes simplifying group by <subquery>

    XMLWordPrintable

Details

    • Bug
    • Status: In Progress (View Workflow)
    • Critical
    • Resolution: Unresolved
    • 10.5.27, 10.6.20, 10.11.10, 11.4.4, 11.7.1
    • 10.5, 10.6, 10.11, 11.4, 11.7
    • Optimizer
    • None

    Description

      running the following

      create table t1 (a int) engine=myisam;
      insert into t1 values (1),(2);
      --echo t1 not const
       
      create table t2 (b int) engine=myisam;
       
      select * from t1, t2 where b in
      ( select (select a from t1 order by b) as d from t1 group by (select d) );
       
      drop table t1, t2;
      

      causes the server to crash in st_select_lex::optimize_unflattened_subqueries()
      JOIN::optimize_stage2 on the join for

      /* select#2 */ select (subquery#3) AS d from t1 group by (subquery#4) having <cache>(t1.a) = <ref_null_helper>((subquery#3))
      

      attempting to update the group list

      (SUBSELECT_ITEM*)((select `d`))
      

      Attachments

        Issue Links

          Activity

            People

              Johnston Rex Johnston
              Johnston Rex Johnston
              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.