[draft] server crash in Field::clone

180508 12:30:07 [ERROR] mysqld got signal 11 ;

Server version: 10.3.7-MariaDB-debug-log

stack_bottom = 0x7fbddc221ec0 thread_stack 0x49000

mysys/stacktrace.c:269(my_print_stacktrace)[0x5583a1ddaae1]

sql/signal_handler.cc:168(handle_fatal_signal)[0x5583a1623f12]

/lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7fbde0d98390]

sql/field.cc:2339(Field::clone(st_mem_root*, TABLE*))[0x5583a15ef247]

sql/table.cc:3230(open_table_from_share(THD*, TABLE_SHARE*, st_mysql_const_lex_string const*, unsigned int, unsigned int, unsigned int, TABLE*, bool, List<String>*))[0x5583a145360e]

sql/sql_base.cc:1928(open_table(THD*, TABLE_LIST*, Open_table_context*))[0x5583a12b6080]

sql/sql_base.cc:3529(open_and_process_table(THD*, LEX*, TABLE_LIST*, unsigned int*, unsigned int, Prelocking_strategy*, bool, Open_table_context*))[0x5583a12b9020]

sql/sql_base.cc:4049(open_tables(THD*, DDL_options_st const&, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*))[0x5583a12ba24b]

sql/sql_base.cc:4924(open_and_lock_table(sTHD*, DDL_options_st const&, TABLE_LIST*, bool, unsigned int, Prelocking_strategy*))[0x5583a12bbf66]

sql/sql_base.h:482(open_and_lock_tables(THD*, DDL_options_st const&, TABLE_LIST*, bool, unsigned int))[0x5583a1357e99]

sql/sql_parse.cc:4186(mysql_execute_command(THD*))[0x5583a1345882]

sql/sql_parse.cc:8001(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x5583a1351cd5]

sql/sql_parse.cc:1848(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5583a133f1f9]

sql/sql_parse.cc:1391(do_command(THD*))[0x5583a133dc31]

sql/sql_connect.cc:1402(do_handle_one_connection(CONNECT*))[0x5583a14a05df]

sql/sql_connect.cc:1309(handle_one_connection)[0x5583a14a035f]

/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7fbde0d8e6ba]

x86_64/clone.S:111(clone)[0x7fbde022341d]

Trying to get some variables.

Some pointers may be invalid and cause the dump to abort.

Query (0x7fbd28013a38): CREATE TABLE transforms.insert_select_21832  SELECT table1.`col_varchar_nokey` AS field1, ( SELECT SQL_SMALL_RESULT MIN( SUBQUERY1_t1.`col_int_key` ) AS SUBQUERY1_field1 FROM ( A AS SUBQUERY1_t1 INNER JOIN ( CC AS SUBQUERY1_t2 INNER JOIN C AS SUBQUERY1_t3 ON (SUBQUERY1_t3.`col_int_nokey` = SUBQUERY1_t2.`col_int_key` ) ) ON (SUBQUERY1_t3.`col_varchar_nokey` = SUBQUERY1_t2.`col_varchar_key` ) ) WHERE SUBQUERY1_t2.`col_int_nokey` <= table1.`col_int_key` AND SUBQUERY1_t1.`col_varchar_nokey` <= SUBQUERY1_t3.`col_varchar_nokey` ) AS field2, ( ( table1.`pk` ) + ( table1.`col_int_key` ) ) AS field3, ( SELECT MAX( SUBQUERY2_t1.`col_int_key` ) AS SUBQUERY2_field1 FROM ( CC AS SUBQUERY2_t1 INNER JOIN ( BB AS SUBQUERY2_t2 STRAIGHT_JOIN BB AS SUBQUERY2_t3 ON (SUBQUERY2_t3.`col_int_nokey` = SUBQUERY2_t2.`pk` ) ) ON (SUBQUERY2_t3.`col_varchar_key` = SUBQUERY2_t2.`col_varchar_nokey` ) ) WHERE SUBQUERY2_t1.`col_int_key` >= table1.`pk` AND SUBQUERY2_t3.`col_varchar_key` >= table1.`col_varchar_key` ) AS field4 FROM ( ( SELECT SUBQUERY3_t1.* FROM C AS SUBQUERY3_t1 ) AS table1 STRAIGHT_JOIN ( ( C AS table2 STRAIGHT_JOIN C AS table3 ON (table3.`col_varchar_key` = table2.`col_varchar_key` ) ) ) ON (table3.`pk` = table2.`col_int_nokey` ) ) WHERE ( EXISTS ( SELECT SUBQUERY4_t1.`col_varchar_key` AS SUBQUERY4_field1 FROM ( C AS SUBQUERY4_t1 INNER JOIN ( D AS SUBQUERY4_t2 INNER JOIN CC AS SUBQUERY4_t3 ON (SUBQUERY4_t3.`col_varchar_key` = SUBQUERY4_t2.`col_varchar_key` ) ) ON (SUBQUERY4_t3.`col_varchar_key` = SUBQUERY4_t2.`col_varchar_nokey` ) ) WHERE SUBQUERY4_t1.`col_varchar_nokey` != table1.`col_varchar_nokey` AND SUBQUERY4_t3.`pk` <= 3 ) ) AND ( table1.`pk` >= table1.`col_int_key` OR table1.`col_int_nokey` IS NOT NULL ) GROUP BY field1, field2, field3, field4 HAVING field3 <> 7 ORDER BY table1.`pk` DESC, field1, field2, field3, field4  /* QNO 112 CON_ID 32 */  /* QNO 145 CON_ID 32 */

Connection ID (thread ID): 32

Status: NOT_KILLED