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

Server crashes in select_union_recursive::create_result_table

    XMLWordPrintable

Details

    Description

      CREATE TABLE t1 (f VARCHAR(1024));
      WITH RECURSIVE cte(f) AS (
        SELECT t1.f FROM t1
          UNION ALL
        SELECT cte.f FROM cte 
      ) 
      SELECT * FROM cte;
      

      Stack trace from 10.2 1da21cd4a58

      #3  <signal handler called>
      #4  0x00007f0fd09d2792 in ha_maria::extra (this=0x7f0fc488a888, operation=HA_EXTRA_WRITE_CACHE) at /data/src/10.2/storage/maria/ha_maria.cc:2550
      #5  0x00007f0fd036e182 in select_union_recursive::create_result_table (this=0x7f0fc49242d0, thd_arg=0x7f0fc4852070, column_types=0x7f0fc4921cc8, is_union_distinct=false, options=2416188160, alias=0x7f0fc4922d68 "cte", bit_fields_as_long=false, create_table=true, keep_row_order=false) at /data/src/10.2/sql/sql_union.cc:242
      #6  0x00007f0fd036f76e in st_select_lex_unit::prepare (this=0x7f0fc4921628, thd_arg=0x7f0fc4852070, sel_result=0x7f0fc4924200, additional_options=0) at /data/src/10.2/sql/sql_union.cc:649
      #7  0x00007f0fd026ae77 in mysql_derived_prepare (thd=0x7f0fc4852070, lex=0x7f0fc4855a20, derived=0x7f0fc4922d70) at /data/src/10.2/sql/sql_derived.cc:724
      #8  0x00007f0fd0269f5e in mysql_handle_single_derived (lex=0x7f0fc4855a20, derived=0x7f0fc4922d70, phases=2) at /data/src/10.2/sql/sql_derived.cc:197
      #9  0x00007f0fd03953ef in TABLE_LIST::handle_derived (this=0x7f0fc4922d70, lex=0x7f0fc4855a20, phases=2) at /data/src/10.2/sql/table.cc:7606
      #10 0x00007f0fd0288a1e in st_select_lex::handle_derived (this=0x7f0fc49224d0, lex=0x7f0fc4855a20, phases=2) at /data/src/10.2/sql/sql_lex.cc:3868
      #11 0x00007f0fd03953b0 in TABLE_LIST::handle_derived (this=0x7f0fc49235b8, lex=0x7f0fc4855a20, phases=2) at /data/src/10.2/sql/table.cc:7603
      #12 0x00007f0fd0288a1e in st_select_lex::handle_derived (this=0x7f0fc4856220, lex=0x7f0fc4855a20, phases=2) at /data/src/10.2/sql/sql_lex.cc:3868
      #13 0x00007f0fd02d1deb in JOIN::prepare (this=0x7f0fc4923cc0, tables_init=0x7f0fc49235b8, wild_num=1, conds_init=0x0, og_num=0, order_init=0x0, skip_order_by=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x7f0fc4856220, unit_arg=0x7f0fc4855ae8) at /data/src/10.2/sql/sql_select.cc:712
      #14 0x00007f0fd02db809 in mysql_select (thd=0x7f0fc4852070, tables=0x7f0fc49235b8, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f0fc4923ca0, unit=0x7f0fc4855ae8, select_lex=0x7f0fc4856220) at /data/src/10.2/sql/sql_select.cc:3518
      #15 0x00007f0fd02d107b in handle_select (thd=0x7f0fc4852070, lex=0x7f0fc4855a20, result=0x7f0fc4923ca0, setup_tables_done_option=0) at /data/src/10.2/sql/sql_select.cc:373
      #16 0x00007f0fd02a0c2b in execute_sqlcom_select (thd=0x7f0fc4852070, all_tables=0x7f0fc49235b8) at /data/src/10.2/sql/sql_parse.cc:6333
      #17 0x00007f0fd0296a61 in mysql_execute_command (thd=0x7f0fc4852070) at /data/src/10.2/sql/sql_parse.cc:3364
      #18 0x00007f0fd02a43e5 in mysql_parse (thd=0x7f0fc4852070, rawbuf=0x7f0fc4921088 "WITH RECURSIVE cte(f) AS (\nSELECT t1.f FROM t1\nUNION ALL\nSELECT cte.f FROM cte \n) \nSELECT * FROM cte", length=100, parser_state=0x7f0fd1216dd0, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7765
      #19 0x00007f0fd02927b8 in dispatch_command (command=COM_QUERY, thd=0x7f0fc4852070, packet=0x7f0fc4915071 "WITH RECURSIVE cte(f) AS (\nSELECT t1.f FROM t1\nUNION ALL\nSELECT cte.f FROM cte \n) \nSELECT * FROM cte", packet_length=100, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1793
      #20 0x00007f0fd02911e9 in do_command (thd=0x7f0fc4852070) at /data/src/10.2/sql/sql_parse.cc:1353
      #21 0x00007f0fd03cb926 in do_handle_one_connection (connect=0x7f0fcd06d410) at /data/src/10.2/sql/sql_connect.cc:1354
      #22 0x00007f0fd03cb6b3 in handle_one_connection (arg=0x7f0fcd06d410) at /data/src/10.2/sql/sql_connect.cc:1260
      #23 0x00007f0fd06c0722 in pfs_spawn_thread (arg=0x7f0fcd0519f0) at /data/src/10.2/storage/perfschema/pfs.cc:1862
      #24 0x00007f0fcf9520a4 in start_thread (arg=0x7f0fd1218300) at pthread_create.c:309
      #25 0x00007f0fcdb0a87d 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.