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

Assertion `select_lex->select_number == (0x7fffffff * 2U + 1U) || select_lex->select_number == 0x7fffffff || !output || !output->get_select(select_lex->select_number) || output->get_select(select_lex->select_number)->select_lex == select_lex' failed

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.4(EOL)
    • 10.4.4
    • Optimizer
    • None

    Description

      set optimizer_switch="condition_pushdown_from_having=on";
      		 
       
      		 
      create table t1 (pk int not null primary key, c1 varchar(64));
      		 
      insert into t1 values (1,'bbb'),(2,'aaa'),(3,'ccc'),(4,	'ddd'),(5,'s'),(7,'c'),(6,'kkk'),(9,'ert'),(8,'s'),(12,'www');
      		 
      create view v1 as select * from t1;
      		 
       
      		 
      select pk from t1 group by  pk 
      having (1 not in (select count(t1.c1) from (v1, t1)));

      10.4 5da6944ea3a592efefd1adc33

      		 
      mysqld: /10.4/sql/sql_select.cc:4102: bool JOIN::save_explain_data(Explain_query*, bool, bool, bool, bool): Assertion `select_lex->select_number == (0x7fffffff * 2U + 1U) || select_lex->select_number == 0x7fffffff || !output || !output->get_select(select_lex->select_number) || output->get_select(select_lex->select_number)->select_lex == select_lex' failed.
      		 
       
      		 
      stdlib/abort.c:91(__GI_abort)[0x7f98fa40902a]
      		 
      assert/assert.c:92(__assert_fail_base)[0x7f98fa3ffbd7]
      		 
      /lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7f98fa3ffc82]
      		 
      sql/sql_select.cc:4104(JOIN::save_explain_data(Explain_query*, bool, bool, bool, bool))[0x558197a99dd1]
      		 
      sql/sql_select.cc:1514(JOIN::build_explain())[0x558197a809b4]
      		 
      sql/sql_select.cc:1567(JOIN::optimize())[0x558197a81278]
      		 
      sql/sql_lex.cc:4151(st_select_lex::optimize_unflattened_subqueries(bool))[0x5581979828ca]
      		 
      sql/opt_subselect.cc:5382(JOIN::optimize_unflattened_subqueries())[0x558197e26015]
      		 
      sql/sql_select.cc:2743(JOIN::optimize_stage2())[0x558197a8ca0f]
      		 
      sql/sql_select.cc:2207(JOIN::optimize_inner())[0x558197a87154]
      		 
      sql/sql_select.cc:1561(JOIN::optimize())[0x558197a811c9]
      		 
      sql/sql_select.cc:4578(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x558197a9e0f5]
      		 
      sql/sql_select.cc:424(handle_select(THD*, LEX*, select_result*, unsigned long))[0x558197a7525c]
      		 
      sql/sql_parse.cc:6602(execute_sqlcom_select(THD*, TABLE_LIST*))[0x5581979fa653]
      		 
      sql/sql_parse.cc:3891(mysql_execute_command(THD*))[0x5581979e7870]
      		 
      sql/sql_parse.cc:8154(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x558197a02914]
      		 
      sql/sql_parse.cc:1834(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5581979db5c4]
      		 
      sql/sql_parse.cc:1365(do_command(THD*))[0x5581979d8503]
      		 
      sql/sql_connect.cc:1398(do_handle_one_connection(CONNECT*))[0x558197d4bf97]
      		 
      sql/sql_connect.cc:1302(handle_one_connection)[0x558197d4b961]
      		 
      perfschema/pfs.cc:1864(pfs_spawn_thread)[0x558199104f0f]
      		 
      /lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f98fb2486ba]
      		 
      x86_64/clone.S:111(clone)[0x7f98fa4d941d]

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          elenst Elena Stepanova added a comment -

          Non-debug build crashes with SIGSEGV:

          10.4 non-debug d2013e73

          		 
          #2  <signal handler called>
          		 
          #3  incr_loops (this=0x88) at /data/src/10.4/sql/sql_analyze_stmt.h:97
          		 
          #4  JOIN::exec (this=0x7f7f14051ca0) at /data/src/10.4/sql/sql_select.cc:4159
          		 
          #5  0x0000560520ac898d in subselect_single_select_engine::exec (this=0x7f7f14015510) at /data/src/10.4/sql/item_subselect.cc:3917
          		 
          #6  0x0000560520ac733d in Item_subselect::exec (this=0x7f7f140152f0) at /data/src/10.4/sql/item_subselect.cc:738
          		 
          #7  0x0000560520ac84df in Item_in_subselect::val_bool (this=0x7f7f140152f0) at /data/src/10.4/sql/item_subselect.cc:1789
          		 
          #8  0x0000560520a6a7ad in Item_in_optimizer::val_int (this=0x7f7f14047e48) at /data/src/10.4/sql/item_cmpfunc.cc:1628
          		 
          #9  0x0000560520966b10 in Type_handler_int_result::Item_val_bool (this=<optimized out>, item=<optimized out>) at /data/src/10.4/sql/sql_type.cc:4386
          		 
          #10 0x0000560520a5f8b7 in Item_func_not::val_int (this=0x7f7f14015550) at /data/src/10.4/sql/item_cmpfunc.cc:200
          		 
          #11 0x000056052094cbbd in and_new_conditions_to_optimized_cond (thd=0x7f7f140009a8, cond=<optimized out>, cond_eq=cond_eq@entry=0x7f7f14046b88, new_conds=..., cond_value=cond_value@entry=0x7f7f14046a60) at /data/src/10.4/sql/opt_subselect.cc:5828
          		 
          #12 0x00005605208888d5 in JOIN::optimize_inner (this=this@entry=0x7f7f14046750) at /data/src/10.4/sql/sql_select.cc:1961
          		 
          #13 0x000056052088aaa5 in JOIN::optimize (this=this@entry=0x7f7f14046750) at /data/src/10.4/sql/sql_select.cc:1561
          		 
          #14 0x000056052088b960 in mysql_select (thd=thd@entry=0x7f7f140009a8, tables=0x7f7f14012638, wild_num=0, fields=..., conds=0x0, og_num=1, order=0x0, group=0x7f7f14012e10, having=0x7f7f14015550, proc_param=0x0, select_options=2147748608, result=0x7f7f14046728, unit=0x7f7f14004718, select_lex=0x7f7f14012070) at /data/src/10.4/sql/sql_select.cc:4578
          		 
          #15 0x000056052088c44e in handle_select (thd=thd@entry=0x7f7f140009a8, lex=lex@entry=0x7f7f14004650, result=result@entry=0x7f7f14046728, setup_tables_done_option=setup_tables_done_option@entry=0) at /data/src/10.4/sql/sql_select.cc:424
          		 
          #16 0x0000560520735d56 in execute_sqlcom_select (thd=thd@entry=0x7f7f140009a8, all_tables=0x7f7f14012638) at /data/src/10.4/sql/sql_parse.cc:6602
          		 
          #17 0x000056052082d363 in mysql_execute_command (thd=thd@entry=0x7f7f140009a8) at /data/src/10.4/sql/sql_parse.cc:3891
          		 
          #18 0x0000560520834c3b in mysql_parse (thd=thd@entry=0x7f7f140009a8, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7f7f302f4170, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.4/sql/sql_parse.cc:8154
          		 
          #19 0x0000560520837d1e in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f7f140009a8, packet=packet@entry=0x7f7f14009bf9 "select pk from t1 group by  pk \nhaving (1 not in (select count(t1.c1) from (v1, t1)))", packet_length=packet_length@entry=85, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.4/sql/sql_parse.cc:1832
          		 
          #20 0x00005605208393c9 in do_command (thd=0x7f7f140009a8) at /data/src/10.4/sql/sql_parse.cc:1365
          		 
          #21 0x000056052091478c in do_handle_one_connection (connect=connect@entry=0x560522c6a888) at /data/src/10.4/sql/sql_connect.cc:1398
          		 
          #22 0x00005605209148f4 in handle_one_connection (arg=arg@entry=0x560522c6a888) at /data/src/10.4/sql/sql_connect.cc:1301
          		 
          #23 0x0000560520c31ac4 in pfs_spawn_thread (arg=0x560522c5e7d8) at /data/src/10.4/storage/perfschema/pfs.cc:1862
          		 
          #24 0x00007f7f3786a494 in start_thread (arg=0x7f7f302f5700) at pthread_create.c:333
          		 
          #25 0x00007f7f35a3893f in clone () from /lib/x86_64-linux-gnu/libc.so.6

          elenst Elena Stepanova added a comment - Non-debug build crashes with SIGSEGV: 10.4 non-debug d2013e73 #2 <signal handler called> #3 incr_loops (this=0x88) at /data/src/10.4/sql/sql_analyze_stmt.h:97 #4 JOIN::exec (this=0x7f7f14051ca0) at /data/src/10.4/sql/sql_select.cc:4159 #5 0x0000560520ac898d in subselect_single_select_engine::exec (this=0x7f7f14015510) at /data/src/10.4/sql/item_subselect.cc:3917 #6 0x0000560520ac733d in Item_subselect::exec (this=0x7f7f140152f0) at /data/src/10.4/sql/item_subselect.cc:738 #7 0x0000560520ac84df in Item_in_subselect::val_bool (this=0x7f7f140152f0) at /data/src/10.4/sql/item_subselect.cc:1789 #8 0x0000560520a6a7ad in Item_in_optimizer::val_int (this=0x7f7f14047e48) at /data/src/10.4/sql/item_cmpfunc.cc:1628 #9 0x0000560520966b10 in Type_handler_int_result::Item_val_bool (this=<optimized out>, item=<optimized out>) at /data/src/10.4/sql/sql_type.cc:4386 #10 0x0000560520a5f8b7 in Item_func_not::val_int (this=0x7f7f14015550) at /data/src/10.4/sql/item_cmpfunc.cc:200 #11 0x000056052094cbbd in and_new_conditions_to_optimized_cond (thd=0x7f7f140009a8, cond=<optimized out>, cond_eq=cond_eq@entry=0x7f7f14046b88, new_conds=..., cond_value=cond_value@entry=0x7f7f14046a60) at /data/src/10.4/sql/opt_subselect.cc:5828 #12 0x00005605208888d5 in JOIN::optimize_inner (this=this@entry=0x7f7f14046750) at /data/src/10.4/sql/sql_select.cc:1961 #13 0x000056052088aaa5 in JOIN::optimize (this=this@entry=0x7f7f14046750) at /data/src/10.4/sql/sql_select.cc:1561 #14 0x000056052088b960 in mysql_select (thd=thd@entry=0x7f7f140009a8, tables=0x7f7f14012638, wild_num=0, fields=..., conds=0x0, og_num=1, order=0x0, group=0x7f7f14012e10, having=0x7f7f14015550, proc_param=0x0, select_options=2147748608, result=0x7f7f14046728, unit=0x7f7f14004718, select_lex=0x7f7f14012070) at /data/src/10.4/sql/sql_select.cc:4578 #15 0x000056052088c44e in handle_select (thd=thd@entry=0x7f7f140009a8, lex=lex@entry=0x7f7f14004650, result=result@entry=0x7f7f14046728, setup_tables_done_option=setup_tables_done_option@entry=0) at /data/src/10.4/sql/sql_select.cc:424 #16 0x0000560520735d56 in execute_sqlcom_select (thd=thd@entry=0x7f7f140009a8, all_tables=0x7f7f14012638) at /data/src/10.4/sql/sql_parse.cc:6602 #17 0x000056052082d363 in mysql_execute_command (thd=thd@entry=0x7f7f140009a8) at /data/src/10.4/sql/sql_parse.cc:3891 #18 0x0000560520834c3b in mysql_parse (thd=thd@entry=0x7f7f140009a8, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7f7f302f4170, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.4/sql/sql_parse.cc:8154 #19 0x0000560520837d1e in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f7f140009a8, packet=packet@entry=0x7f7f14009bf9 "select pk from t1 group by pk \nhaving (1 not in (select count(t1.c1) from (v1, t1)))", packet_length=packet_length@entry=85, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.4/sql/sql_parse.cc:1832 #20 0x00005605208393c9 in do_command (thd=0x7f7f140009a8) at /data/src/10.4/sql/sql_parse.cc:1365 #21 0x000056052091478c in do_handle_one_connection (connect=connect@entry=0x560522c6a888) at /data/src/10.4/sql/sql_connect.cc:1398 #22 0x00005605209148f4 in handle_one_connection (arg=arg@entry=0x560522c6a888) at /data/src/10.4/sql/sql_connect.cc:1301 #23 0x0000560520c31ac4 in pfs_spawn_thread (arg=0x560522c5e7d8) at /data/src/10.4/storage/perfschema/pfs.cc:1862 #24 0x00007f7f3786a494 in start_thread (arg=0x7f7f302f5700) at pthread_create.c:333 #25 0x00007f7f35a3893f in clone () from /lib/x86_64-linux-gnu/libc.so.6
          shagalla Galina Shalygina (Inactive) added a comment -

          Pushed in 10.4

          shagalla Galina Shalygina (Inactive) added a comment - Pushed in 10.4

          People

            allen.herrera Allen Herrera
            alice Alice Sherepa
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.