CREATE TABLE t1 (a INT);

CREATE TABLE t2 (b INT);

LOCK TABLE t1 WRITE, t2 WRITE;

--error ER_DATA_TOO_LONG

CREATE OR REPLACE TABLE t1 (a CHAR(1)) AS SELECT 'foo' AS a;

# Cleanup

UNLOCK TABLES;

DROP TABLE IF EXISTS t1, t2;

mysqld: /data/src/10.2/sql/sql_base.cc:880: void close_thread_table(THD*, TABLE**): Assertion `thd->mdl_context.is_lock_owner(MDL_key::TABLE, table->s->db.str, table->s->table_name.str, MDL_SHARED)' failed.

200916  0:23:53 [ERROR] mysqld got signal 6 ;

#7  0x00007f680ea9ff36 in __GI___assert_fail (assertion=0x55898a86bc30 "thd->mdl_context.is_lock_owner(MDL_key::TABLE, table->s->db.str, table->s->table_name.str, MDL_SHARED)", file=0x55898a86b798 "/data/src/10.2/sql/sql_base.cc", line=880, function=0x55898a86bbb0 "void close_thread_table(THD*, TABLE**)") at assert.c:101

#8  0x0000558989d391af in close_thread_table (thd=0x7f67f8000d90, table_ptr=0x7f67f8000e70) at /data/src/10.2/sql/sql_base.cc:880

#9  0x0000558989d39def in drop_open_table (thd=0x7f67f8000d90, table=0x7f67f80a04a0, db_name=0x7f67f8012e50 "test", table_name=0x7f67f80127e8 "t1") at /data/src/10.2/sql/sql_base.cc:1272

#10 0x0000558989d93857 in select_create::abort_result_set (this=0x7f67f80130e8) at /data/src/10.2/sql/sql_insert.cc:4719

#11 0x0000558989decf48 in handle_select (thd=0x7f67f8000d90, lex=0x7f67f80048c8, result=0x7f67f80130e8, setup_tables_done_option=0) at /data/src/10.2/sql/sql_select.cc:379

#12 0x0000558989e8db19 in Sql_cmd_create_table::execute (this=0x7f67f8012818, thd=0x7f67f8000d90) at /data/src/10.2/sql/sql_table.cc:10944

#13 0x0000558989db6a41 in mysql_execute_command (thd=0x7f67f8000d90) at /data/src/10.2/sql/sql_parse.cc:5964

#14 0x0000558989dbba57 in mysql_parse (thd=0x7f67f8000d90, rawbuf=0x7f67f80126f8 "CREATE OR REPLACE TABLE t1 (a CHAR(1)) AS SELECT 'foo' AS a", length=59, parser_state=0x7f6808bfa5f0, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7733

#15 0x0000558989da9d66 in dispatch_command (command=COM_QUERY, thd=0x7f67f8000d90, packet=0x7f67f8008b51 "CREATE OR REPLACE TABLE t1 (a CHAR(1)) AS SELECT 'foo' AS a", packet_length=59, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1823

#16 0x0000558989da8861 in do_command (thd=0x7f67f8000d90) at /data/src/10.2/sql/sql_parse.cc:1377

#17 0x0000558989f02233 in do_handle_one_connection (connect=0x55898c383aa0) at /data/src/10.2/sql/sql_connect.cc:1336

#18 0x0000558989f01f98 in handle_one_connection (arg=0x55898c383aa0) at /data/src/10.2/sql/sql_connect.cc:1241

#19 0x000055898a726514 in pfs_spawn_thread (arg=0x55898c38c770) at /data/src/10.2/storage/perfschema/pfs.cc:1869

#20 0x00007f680efb1609 in start_thread (arg=<optimized out>) at pthread_create.c:477

#21 0x00007f680eb8b103 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

mariadbd: /data/src/10.5/sql/table_cache.cc:1253: void TDC_element::flush(THD*, bool): Assertion `thd->mdl_context.is_lock_owner(MDL_key::TABLE, share->db.str, share->table_name.str, MDL_EXCLUSIVE)' failed.

200916  0:26:19 [ERROR] mysqld got signal 6 ;

#7  0x00007f6dbf767f36 in __GI___assert_fail (assertion=0x5625d608a3a8 "thd->mdl_context.is_lock_owner(MDL_key::TABLE, share->db.str, share->table_name.str, MDL_EXCLUSIVE)", file=0x5625d6089bb0 "/data/src/10.5/sql/table_cache.cc", line=1253, function=0x5625d608a548 "void TDC_element::flush(THD*, bool)") at assert.c:101

#8  0x00005625d53ef013 in TDC_element::flush (this=0x7f6da805c258, thd=0x7f6da8000db8, mark_flushed=true) at /data/src/10.5/sql/table_cache.cc:1253

#9  0x00005625d50af7ce in drop_open_table (thd=0x7f6da8000db8, table=0x7f6da80436a8, db_name=0x7f6da8014078, table_name=0x7f6da8014088) at /data/src/10.5/sql/sql_base.cc:1355

#10 0x00005625d5119702 in select_create::abort_result_set (this=0x7f6da80156c8) at /data/src/10.5/sql/sql_insert.cc:5092

#11 0x00005625d51a3ad9 in handle_select (thd=0x7f6da8000db8, lex=0x7f6da8004e88, result=0x7f6da80156c8, setup_tables_done_option=0) at /data/src/10.5/sql/sql_select.cc:435

#12 0x00005625d526a5ac in Sql_cmd_create_table_like::execute (this=0x7f6da8014000, thd=0x7f6da8000db8) at /data/src/10.5/sql/sql_table.cc:11964

#13 0x00005625d51659be in mysql_execute_command (thd=0x7f6da8000db8) at /data/src/10.5/sql/sql_parse.cc:5952

#14 0x00005625d516bdd2 in mysql_parse (thd=0x7f6da8000db8, rawbuf=0x7f6da8013f20 "CREATE OR REPLACE TABLE t1 (a CHAR(1)) AS SELECT 'foo' AS a", length=59, parser_state=0x7f6dba124510, is_com_multi=false, is_next_command=false) at /data/src/10.5/sql/sql_parse.cc:7994

#15 0x00005625d5158110 in dispatch_command (command=COM_QUERY, thd=0x7f6da8000db8, packet=0x7f6da8009099 "CREATE OR REPLACE TABLE t1 (a CHAR(1)) AS SELECT 'foo' AS a", packet_length=59, is_com_multi=false, is_next_command=false) at /data/src/10.5/sql/sql_parse.cc:1867

#16 0x00005625d5156904 in do_command (thd=0x7f6da8000db8) at /data/src/10.5/sql/sql_parse.cc:1348

#17 0x00005625d53026dc in do_handle_one_connection (connect=0x5625d85a2f68, put_in_cache=true) at /data/src/10.5/sql/sql_connect.cc:1410

#18 0x00005625d5302444 in handle_one_connection (arg=0x5625d8657d28) at /data/src/10.5/sql/sql_connect.cc:1312

#19 0x00005625d585cf15 in pfs_spawn_thread (arg=0x5625d85a2ba8) at /data/src/10.5/storage/perfschema/pfs.cc:2201

#20 0x00007f6dbfc7f609 in start_thread (arg=<optimized out>) at pthread_create.c:477

#21 0x00007f6dbf853103 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

SET SESSION default_storage_engine=mrg_myisam;

CREATE TABLE t (a INT);

LOCK TABLES t WRITE;

CREATE or REPLACE TABLE t AS SELECT 1 AS a;

Core was generated by `/test/MD150920-mariadb-10.5.6-linux-x86_64-opt/bin/mysqld --no-defaults --core-'.

Program terminated with signal SIGSEGV, Segmentation fault.

#0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=11)

    at ../sysdeps/unix/sysv/linux/pthread_kill.c:57

[Current thread is 1 (Thread 0x14b4d0555700 (LWP 499383))]

(gdb) bt

#0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57

#1  0x000055c8b63a4ae7 in my_write_core (sig=sig@entry=11) at /data/10.5_opt/mysys/stacktrace.c:424

#2  0x000055c8b5d73fda in handle_fatal_signal (sig=11) at /data/10.5_opt/sql/signal_handler.cc:330

#3  <signal handler called>

#4  close_thread_table (thd=thd@entry=0x14b4ac012018, table_ptr=table_ptr@entry=0x14b4ac0120f8) at /data/10.5_opt/sql/sql_base.cc:946

#5  0x000055c8b5b14cf9 in drop_open_table (thd=0x14b4ac012018, table=0x14b4ac05c418, db_name=0x14b4ac047168, table_name=0x14b4ac047178) at /data/10.5_opt/sql/sql_base.cc:1356

#6  0x000055c8b5b44236 in select_create::abort_result_set (this=0x14b4ac048590) at /data/10.5_opt/sql/sql_insert.cc:5092

#7  0x000055c8b5bd80ba in handle_select (thd=thd@entry=0x14b4ac012018, lex=lex@entry=0x14b4ac015f28, result=result@entry=0x14b4ac048590, setup_tables_done_option=setup_tables_done_option@entry=0) at /data/10.5_opt/sql/sql_select.cc:435

#8  0x000055c8b5c1019a in Sql_cmd_create_table_like::execute (this=<optimized out>, thd=0x14b4ac012018) at /data/10.5_opt/sql/sql_table.cc:11964

#9  0x000055c8b5b79eff in mysql_execute_command (thd=thd@entry=0x14b4ac012018) at /data/10.5_opt/sql/sql_parse.cc:5952

#10 0x000055c8b5b80a2c in mysql_parse (thd=0x14b4ac012018, rawbuf=<optimized out>, length=42, parser_state=0x14b4d0554430, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /data/10.5_opt/sql/sql_parse.cc:7994

#11 0x000055c8b5b75cc5 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x14b4ac012018, packet=packet@entry=0x14b4ac03a019 "CREATE or REPLACE TABLE t AS SELECT 1 AS a", packet_length=packet_length@entry=42, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/10.5_opt/sql/sql_parse.cc:1867

#12 0x000055c8b5b73fe4 in do_command (thd=0x14b4ac012018) at /data/10.5_opt/sql/sql_parse.cc:1348

#13 0x000055c8b5c6aba1 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x14b4cd4338f8, put_in_cache=put_in_cache@entry=true) at /data/10.5_opt/sql/sql_connect.cc:1410

#14 0x000055c8b5c6af14 in handle_one_connection (arg=arg@entry=0x14b4cd4338f8) at /data/10.5_opt/sql/sql_connect.cc:1312

#15 0x000055c8b5fdea4a in pfs_spawn_thread (arg=0x14b4cd44f018) at /data/10.5_opt/storage/perfschema/pfs.cc:2201

#16 0x000014b4cf4ce6db in start_thread (arg=0x14b4d0555700) at pthread_create.c:463

#17 0x000014b4ce8cca3f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

mysqld: /test/10.5_dbg/sql/sql_base.cc:943: void close_thread_table(THD*, TABLE**): Assertion `thd->mdl_context.is_lock_owner(MDL_key::TABLE, table->s->db.str, table->s->table_name.str, MDL_SHARED)' failed.

Core was generated by `/test/MD150920-mariadb-10.5.6-linux-x86_64-dbg/bin/mysqld --no-defaults --core-'.

Program terminated with signal SIGABRT, Aborted.

#0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6)

    at ../sysdeps/unix/sysv/linux/pthread_kill.c:57

[Current thread is 1 (Thread 0x1513508a0700 (LWP 607600))]

(gdb) bt

#0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57

#1  0x000055a2721be85a in my_write_core (sig=sig@entry=6) at /test/10.5_dbg/mysys/stacktrace.c:424

#2  0x000055a2719853a9 in handle_fatal_signal (sig=6) at /test/10.5_dbg/sql/signal_handler.cc:330

#3  <signal handler called>

#4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:51

#5  0x000015134eb368b1 in __GI_abort () at abort.c:79

#6  0x000015134eb2642a in __assert_fail_base (fmt=0x15134ecada38 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x55a272329ef8 "thd->mdl_context.is_lock_owner(MDL_key::TABLE, table->s->db.str, table->s->table_name.str, MDL_SHARED)", file=file@entry=0x55a272329ad0 "/test/10.5_dbg/sql/sql_base.cc", line=line@entry=943, function=function@entry=0x55a27232d720 <close_thread_table(THD*, TABLE**)::__PRETTY_FUNCTION__> "void close_thread_table(THD*, TABLE**)") at assert.c:92

#7  0x000015134eb264a2 in __GI___assert_fail (assertion=assertion@entry=0x55a272329ef8 "thd->mdl_context.is_lock_owner(MDL_key::TABLE, table->s->db.str, table->s->table_name.str, MDL_SHARED)", file=file@entry=0x55a272329ad0 "/test/10.5_dbg/sql/sql_base.cc", line=line@entry=943, function=function@entry=0x55a27232d720 <close_thread_table(THD*, TABLE**)::__PRETTY_FUNCTION__> "void close_thread_table(THD*, TABLE**)") at assert.c:101

#8  0x000055a27164b20c in close_thread_table (thd=thd@entry=0x15132c815088, table_ptr=table_ptr@entry=0x15132c815168) at /test/10.5_dbg/sql/sql_base.cc:940

#9  0x000055a27164b78a in close_thread_tables (thd=thd@entry=0x15132c815088) at /test/10.5_dbg/sql/sql_base.cc:919

#10 0x000055a27164cd68 in Locked_tables_list::unlock_locked_tables (this=this@entry=0x15132c819058, thd=thd@entry=0x15132c815088) at /test/10.5_dbg/sql/sql_base.cc:2359

#11 0x000055a27164ce4d in Locked_tables_list::unlock_locked_table (this=0x15132c819058, thd=0x15132c815088, mdl_ticket=<optimized out>) at /test/10.5_dbg/sql/sql_base.cc:2402

#12 0x000055a271690011 in select_create::abort_result_set (this=0x15132c875600) at /test/10.5_dbg/sql/sql_insert.cc:5063

#13 0x000055a271752152 in handle_select (thd=thd@entry=0x15132c815088, lex=lex@entry=0x15132c819158, result=result@entry=0x15132c875600, setup_tables_done_option=setup_tables_done_option@entry=0) at /test/10.5_dbg/sql/sql_select.cc:435

#14 0x000055a2717a7fb8 in Sql_cmd_create_table_like::execute (this=0x15132c874160, thd=0x15132c815088) at /test/10.5_dbg/sql/sql_table.cc:11964

#15 0x000055a2716d79b0 in mysql_execute_command (thd=thd@entry=0x15132c815088) at /test/10.5_dbg/sql/sql_parse.cc:5952

#16 0x000055a2716df324 in mysql_parse (thd=thd@entry=0x15132c815088, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x15135089f350, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.5_dbg/sql/sql_parse.cc:7994

#17 0x000055a2716cbd54 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x15132c815088, packet=packet@entry=0x15132c867089 "CREATE or REPLACE TABLE t AS SELECT 1 AS a", packet_length=packet_length@entry=42, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.5_dbg/sql/sql_parse.cc:1867

#18 0x000055a2716ca53e in do_command (thd=0x15132c815088) at /test/10.5_dbg/sql/sql_parse.cc:1348

#19 0x000055a271829893 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x15132f8d4808, put_in_cache=put_in_cache@entry=true) at /test/10.5_dbg/sql/sql_connect.cc:1410

#20 0x000055a271829fb7 in handle_one_connection (arg=arg@entry=0x15132f8d4808) at /test/10.5_dbg/sql/sql_connect.cc:1312

#21 0x000055a271c945c2 in pfs_spawn_thread (arg=0x15134d446508) at /test/10.5_dbg/storage/perfschema/pfs.cc:2201

#22 0x000015134f8196db in start_thread (arg=0x1513508a0700) at pthread_create.c:463

#23 0x000015134ec17a3f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

10.5.6>CREATE TABLE t1 (a INT);

Query OK, 0 rows affected (0.011 sec)

10.5.6>CREATE TABLE t2 (b INT);

Query OK, 0 rows affected (0.010 sec)

10.5.6>LOCK TABLE t1 WRITE, t2 WRITE;

Query OK, 0 rows affected (0.000 sec)

10.5.6>CREATE OR REPLACE TABLE t1 (a CHAR(1)) AS SELECT 'foo' AS a;

ERROR 1406 (22001): Data too long for column 'a' at row 1

10.5.6>CREATE OR REPLACE TABLE t1 (a CHAR(1)) AS SELECT 'foo' AS a;

ERROR 1100 (HY000): Table 't1' was not locked with LOCK TABLES    ### (!)

10.5.6>SHOW CREATE TABLE t1;

ERROR 1100 (HY000): Table 't1' was not locked with LOCK TABLES    ### (!)

10.5.6>LOCK TABLE t1 WRITE;

ERROR 1146 (42S02): Table 'test.t1' doesn't exist    ### (!)

10.5.6>SHOW CREATE TABLE t1;

ERROR 1146 (42S02): Table 'test.t1' doesn't exist    ### (!)

SIGSEGV|close_thread_table|drop_open_table|select_create::abort_result_set|handle_select 

thd->mdl_context.is_lock_owner(MDL_key::TABLE, table->s->db.str, table->s->table_name.str, MDL_SHARED)|SIGABRT|close_thread_table|close_thread_tables|Locked_tables_list::unlock_locked_tables|Locked_tables_list::unlock_locked_table

thd->transaction->stmt.is_empty()|SIGABRT|Locked_tables_list::unlock_locked_tables|Locked_tables_list::unlock_locked_table|select_create::abort_result_set|handle_select                                                         

thd->mdl_context.is_lock_owner(MDL_key::TABLE, share->db.str, share->table_name.str, MDL_EXCLUSIVE)|SIGABRT|TDC_element::flush|drop_open_table|select_create::abort_result_set|handle_select