Details

      Description

      Note: The test case was originally filed in MDEV-17021, but now moved from it because the analysis shows it's unrelated.

      CREATE TABLE t1 (a INT(45));
      INSERT IGNORE INTO t1 VALUES (1),(2);
      CREATE TABLE t2 ENGINE=Aria AS SELECT SUM(a) AS f1, IFNULL( 'qux', ExtractValue( 'foo', 'bar' ) ) AS f2 FROM t1;
       
      # Cleanup
      DROP TABLE t1, t2;
      

      10.0 bcc677bb726

      #3  <signal handler called>
      #4  0x00007f6d295d3d8c in __memmove_avx_unaligned_erms () from /lib/x86_64-linux-gnu/libc.so.6
      #5  0x0000000000a4a2de in write_block_record (info=0x7f6d21bf1070, old_record=0x0, record=0x7f6d21828488 "\374\200", row=0x7f6d21bf10d8, bitmap_blocks=0x7f6d21bf10d8, head_block_is_read=0 '\000', row_pos=0x7f6d2b55c440, undo_lsn=1, old_record_checksum=0) at /data/src/10.0/storage/maria/ma_blockrec.c:2805
      #6  0x0000000000a4bf56 in allocate_and_write_block_record (info=0x7f6d21bf1070, record=0x7f6d21828488 "\374\200", row=0x7f6d21bf10d8, undo_lsn=1) at /data/src/10.0/storage/maria/ma_blockrec.c:3529
      #7  0x0000000000a4c069 in _ma_write_init_block_record (info=0x7f6d21bf1070, record=0x7f6d21828488 "\374\200") at /data/src/10.0/storage/maria/ma_blockrec.c:3569
      #8  0x0000000000a5c6e0 in maria_write (info=0x7f6d21bf1070, record=0x7f6d21828488 "\374\200") at /data/src/10.0/storage/maria/ma_write.c:156
      #9  0x00000000009ebf79 in ha_maria::write_row (this=0x7f6d2187f088, buf=0x7f6d21828488 "\374\200") at /data/src/10.0/storage/maria/ha_maria.cc:1281
      #10 0x0000000000848064 in handler::ha_write_row (this=0x7f6d2187f088, buf=0x7f6d21828488 "\374\200") at /data/src/10.0/sql/handler.cc:6033
      #11 0x0000000000631bb0 in write_record (thd=0x7f6d236a8070, table=0x7f6d2189f070, info=0x7f6d218fb870) at /data/src/10.0/sql/sql_insert.cc:1849
      #12 0x00000000006366f2 in select_insert::send_data (this=0x7f6d218fb838, values=...) at /data/src/10.0/sql/sql_insert.cc:3644
      #13 0x00000000006b0d76 in end_send_group (join=0x7f6d218fb918, join_tab=0x7f6d21bb7be8, end_of_records=true) at /data/src/10.0/sql/sql_select.cc:19259
      #14 0x00000000006ada3e in sub_select (join=0x7f6d218fb918, join_tab=0x7f6d21bb78c0, end_of_records=true) at /data/src/10.0/sql/sql_select.cc:17950
      #15 0x00000000006ad52f in do_select (join=0x7f6d218fb918, fields=0x7f6d218fbd00, table=0x0, procedure=0x0) at /data/src/10.0/sql/sql_select.cc:17661
      #16 0x000000000068a141 in JOIN::exec_inner (this=0x7f6d218fb918) at /data/src/10.0/sql/sql_select.cc:3123
      #17 0x00000000006875fe in JOIN::exec (this=0x7f6d218fb918) at /data/src/10.0/sql/sql_select.cc:2409
      #18 0x000000000068a9a0 in mysql_select (thd=0x7f6d236a8070, rref_pointer_array=0x7f6d236ac3a0, tables=0x7f6d218fb080, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2416184064, result=0x7f6d218fb838, unit=0x7f6d236aba08, select_lex=0x7f6d236ac0f8) at /data/src/10.0/sql/sql_select.cc:3348
      #19 0x0000000000680a14 in handle_select (thd=0x7f6d236a8070, lex=0x7f6d236ab940, result=0x7f6d218fb838, setup_tables_done_option=0) at /data/src/10.0/sql/sql_select.cc:377
      #20 0x000000000064e4f6 in mysql_execute_command (thd=0x7f6d236a8070) at /data/src/10.0/sql/sql_parse.cc:3012
      #21 0x0000000000657d64 in mysql_parse (thd=0x7f6d236a8070, rawbuf=0x7f6d218fa088 "CREATE TABLE t2 ENGINE=Aria AS SELECT SUM(a) AS f1, IFNULL( 'qux', ExtractValue( 'foo', 'bar' ) ) AS f2 FROM t1", length=111, parser_state=0x7f6d2b55d640) at /data/src/10.0/sql/sql_parse.cc:6637
      #22 0x000000000064a684 in dispatch_command (command=COM_QUERY, thd=0x7f6d236a8070, packet=0x7f6d24be5071 "CREATE TABLE t2 ENGINE=Aria AS SELECT SUM(a) AS f1, IFNULL( 'qux', ExtractValue( 'foo', 'bar' ) ) AS f2 FROM t1", packet_length=111) at /data/src/10.0/sql/sql_parse.cc:1300
      #23 0x0000000000649984 in do_command (thd=0x7f6d236a8070) at /data/src/10.0/sql/sql_parse.cc:1003
      #24 0x000000000076acdc in do_handle_one_connection (thd_arg=0x7f6d236a8070) at /data/src/10.0/sql/sql_connect.cc:1377
      #25 0x000000000076aa4e in handle_one_connection (arg=0x7f6d236a8070) at /data/src/10.0/sql/sql_connect.cc:1292
      #26 0x0000000000accef0 in pfs_spawn_thread (arg=0x7f6d235a25f0) at /data/src/10.0/storage/perfschema/pfs.cc:1861
      #27 0x00007f6d2b1da494 in start_thread (arg=0x7f6d2b55e700) at pthread_create.c:333
      #28 0x00007f6d2959393f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

        Attachments

          Activity

            People

            • Assignee:
              monty Michael Widenius
              Reporter:
              elenst Elena Stepanova
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: