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

crash in Item_subselect::init_expr_cache_tracker

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 10.6.3
    • Fix Version/s: N/A
    • Component/s: Optimizer
    • Labels:
      None
    • Environment:
      Linux x64

      Description

      Version: '10.6.3-MariaDB'  MariaDB Server
      Thread 14 "mysqld" received signal SIGSEGV, Segmentation fault.
       
      (gdb) bt
      #0  in Item_subselect::init_expr_cache_tracker at ./sql/item_subselect.cc:7003
      #1  in Item_singlerow_subselect::expr_cache_insert_transformer at ./sql/item_subselect.cc:1389
      #2  in JOIN::setup_subquery_caches at ./sql/sql_select.cc:4225
      #3  in JOIN::optimize_stage2 at ./sql/sql_select.cc:3065
      #4  in JOIN::optimize_inner at ./sql/sql_select.cc:2477
      #5  in JOIN::optimize at ./sql/sql_select.cc:1807
      #6  in st_select_lex::optimize_unflattened_subqueries at ./sql/sql_lex.cc:4937
      #7  in JOIN::optimize_constant_subqueries at ./sql/opt_subselect.cc:5601
      #8  in JOIN::optimize_inner at ./sql/sql_select.cc:2127
      #9  in JOIN::optimize at ./sql/sql_select.cc:1807
      #10 in mysql_select at ./sql/sql_select.cc:4968
      #11 in handle_select at ./sql/sql_select.cc:556
      #12 in execute_sqlcom_select at ./sql/sql_parse.cc:6252
      #13 in mysql_execute_command at ./sql/sql_parse.cc:3947
      #14 in mysql_parse at ./sql/sql_parse.cc:8026
      #15 in dispatch_command  at ./sql/sql_parse.cc:1896
      #16 in do_command at ./sql/sql_parse.cc:1405
      #17 in do_handle_one_connection at ./sql/sql_connect.cc:1410
      #18 in handle_one_connection at ./sql/sql_connect.cc:1312
      #19 in pfs_spawn_thread at ./storage/perfschema/pfs.cc:2201
      #20 in start_thread at pthread_create.c:481
      #21 in clone 
      

      Testcase

      drop table if exists t;
      create table t(a int);
       
      select 1 from t where not exists 
      ( 
        select 1 from t where binary current_time()
        group by (select a),(select 1)
      );
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              sbester1 sbester1
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration