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

Server crashes simplifying group by <subquery>

    XMLWordPrintable

Details

    • Bug
    • Status: Stalled (View Workflow)
    • Critical
    • Resolution: Unresolved
    • 10.5.27, 10.6.20, 10.11.10, 11.4.4, 11.7.1
    • 10.11, 11.4, 11.8
    • 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

          is blocked by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35673 Correlated subquery problems causing wrong results and server crash

          • Critical - Crashes, loss of data, severe memory leak.
          • In Review
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-36576 a NULL pointer dereference located in update_depend_map_for_order function in sql/sql_select.cc at line 16641

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-30756 Crash in get_sort_by_table / make_join_statistics / update_depend_map_for_order, various UBSAN pointer issues

          • Major - Major loss of function.
          • Stalled

          Activity

            People

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