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

Assertion `tab > tab->join->join_tab || !tables_list' failed in JOIN::create_postjoin_aggr_table

    XMLWordPrintable

Details

    Description

      CREATE TABLE t1 (i INT);
      SELECT COUNT(*) OVER () FROM t1 WHERE 0;
      

      10.2 abe6aca8d46a570a4

      mysqld: /data/src/10.2/sql/sql_select.cc:2782: bool JOIN::create_postjoin_aggr_table(JOIN_TAB*, List<Item>*, ORDER*, bool, bool, bool): Assertion `tab > tab->join->join_tab || !tables_list' failed.
      170208  0:21:46 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007f128bd21312 in __GI___assert_fail (assertion=0x7f128f293858 "tab > tab->join->join_tab || !tables_list", file=0x7f128f2932e8 "/data/src/10.2/sql/sql_select.cc", line=2782, function=0x7f128f295d40 <JOIN::create_postjoin_aggr_table(st_join_table*, List<Item>*, st_order*, bool, bool, bool)::__PRETTY_FUNCTION__> "bool JOIN::create_postjoin_aggr_table(JOIN_TAB*, List<Item>*, ORDER*, bool, bool, bool)") at assert.c:101
      #8  0x00007f128e84c6bf in JOIN::create_postjoin_aggr_table (this=0x7f1283064c80, tab=0x7f12830652d0, table_fields=0x7f1283064f90, table_group=0x0, save_sum_fields=false, distinct=false, keep_row_order=false) at /data/src/10.2/sql/sql_select.cc:2782
      #9  0x00007f128e84aa30 in JOIN::make_aggr_tables_info (this=0x7f1283064c80) at /data/src/10.2/sql/sql_select.cc:2355
      #10 0x00007f128e849d6d in JOIN::optimize_inner (this=0x7f1283064c80) at /data/src/10.2/sql/sql_select.cc:2137
      #11 0x00007f128e84639e in JOIN::optimize (this=0x7f1283064c80) at /data/src/10.2/sql/sql_select.cc:1076
      #12 0x00007f128e84ee98 in mysql_select (thd=0x7f1283016070, tables=0x7f12830644e0, wild_num=0, fields=..., conds=0x7f1283064b08, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f1283064c60, unit=0x7f1283019b58, select_lex=0x7f128301a288) at /data/src/10.2/sql/sql_select.cc:3588
      #13 0x00007f128e843de1 in handle_select (thd=0x7f1283016070, lex=0x7f1283019a90, result=0x7f1283064c60, setup_tables_done_option=0) at /data/src/10.2/sql/sql_select.cc:373
      #14 0x00007f128e8102db in execute_sqlcom_select (thd=0x7f1283016070, all_tables=0x7f12830644e0) at /data/src/10.2/sql/sql_parse.cc:6399
      #15 0x00007f128e8062f5 in mysql_execute_command (thd=0x7f1283016070) at /data/src/10.2/sql/sql_parse.cc:3429
      #16 0x00007f128e813cac in mysql_parse (thd=0x7f1283016070, rawbuf=0x7f1283064088 "SELECT COUNT(*) OVER () FROM t1 WHERE 0", length=39, parser_state=0x7f128f927dd0, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7842
      #17 0x00007f128e801db7 in dispatch_command (command=COM_QUERY, thd=0x7f1283016070, packet=0x7f1283058071 "SELECT COUNT(*) OVER () FROM t1 WHERE 0", packet_length=39, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1800
      #18 0x00007f128e8007af in do_command (thd=0x7f1283016070) at /data/src/10.2/sql/sql_parse.cc:1360
      #19 0x00007f128e9491e8 in do_handle_one_connection (connect=0x7f128b471410) at /data/src/10.2/sql/sql_connect.cc:1354
      #20 0x00007f128e948f75 in handle_one_connection (arg=0x7f128b471410) at /data/src/10.2/sql/sql_connect.cc:1260
      #21 0x00007f128ec8da36 in pfs_spawn_thread (arg=0x7f128b40f9f0) at /data/src/10.2/storage/perfschema/pfs.cc:1862
      #22 0x00007f128de2e0a4 in start_thread (arg=0x7f128f929300) at pthread_create.c:309
      #23 0x00007f128bddb87d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
      

      Attachments

        Activity

          People

            igor Igor Babaev
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.