Assertion failure: thd->mdl_context.is_lock_owner(MDL_key::TABLE

  Thread 36 "mysqld" received signal SIGABRT, Aborted.

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

  51	../sysdeps/unix/sysv/linux/raise.c: No such file or directory.

(gdb) wher

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

  #1  0x00007ffff54d8801 in __GI_abort () at abort.c:79

  #2  0x00007ffff54c839a in __assert_fail_base (fmt=0x7ffff564f7d8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x55555696db10 "thd->mdl_context.is_lock_owner(MDL_key::TABLE, table->s->db.str, table->s->table_name.str, MDL_SHARED)", file=file@entry=0x55555696d738 "/home/psergey/dev-git/10.4/sql/sql_base.cc", line=line@entry=1044, function=function@entry=0x55555696f480 <close_thread_table(THD*, TABLE**)::__PRETTY_FUNCTION__> "void close_thread_table(THD*, TABLE**)") at assert.c:92

  #3  0x00007ffff54c8412 in __GI___assert_fail (assertion=0x55555696db10 "thd->mdl_context.is_lock_owner(MDL_key::TABLE, table->s->db.str, table->s->table_name.str, MDL_SHARED)", file=0x55555696d738 "/home/psergey/dev-git/10.4/sql/sql_base.cc", line=1044, function=0x55555696f480 <close_thread_table(THD*, TABLE**)::__PRETTY_FUNCTION__> "void close_thread_table(THD*, TABLE**)") at assert.c:101

  #4  0x0000555555c9bd00 in close_thread_table (thd=0x7ffe64000cf8, table_ptr=0x7ffe64000de0) at /home/psergey/dev-git/10.4/sql/sql_base.cc:1041

  #5  0x0000555555c9bae4 in close_thread_tables (thd=0x7ffe64000cf8) at /home/psergey/dev-git/10.4/sql/sql_base.cc:1020

  #6  0x0000555555d46fd4 in mysql_execute_command (thd=0x7ffe64000cf8) at /home/psergey/dev-git/10.4/sql/sql_parse.cc:6148

  #7  0x0000555555d4bc5f in mysql_parse (thd=0x7ffe64000cf8, rawbuf=0x7ffe6406b8e0 "explain select * from one_k where a in (select t10.b from t10, t11, t12, t13, t14 where t11.a=t10.b+1 and t12.a=t10.b and t13.a=t10.b and t14.a=t10.b)", length=150, parser_state=0x7ffff0202150, is_com_multi=false, is_next_command=false) at /home/psergey/dev-git/10.4/sql/sql_parse.cc:7892

  #8  0x0000555555d37da2 in dispatch_command (command=COM_QUERY, thd=0x7ffe64000cf8, packet=0x7ffe64007de9 "", packet_length=150, is_com_multi=false, is_next_command=false) at /home/psergey/dev-git/10.4/sql/sql_parse.cc:1826

  #9  0x0000555555d3655f in do_command (thd=0x7ffe64000cf8) at /home/psergey/dev-git/10.4/sql/sql_parse.cc:1359

  #10 0x0000555555eb58e4 in do_handle_one_connection (connect=0x55556522fec8) at /home/psergey/dev-git/10.4/sql/sql_connect.cc:1404

  #11 0x0000555555eb5633 in handle_one_connection (arg=0x55556522fec8) at /home/psergey/dev-git/10.4/sql/sql_connect.cc:1306

  #12 0x000055555683a6f4 in pfs_spawn_thread (arg=0x555565132818) at /home/psergey/dev-git/10.4/storage/perfschema/pfs.cc:1862

  #13 0x00007ffff63d36db in start_thread (arg=0x7ffff0203700) at pthread_create.c:463

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

(gdb) p table->alias

  $19 = {<Charset> = {m_charset = 0x555557435880 <my_charset_bin>}, <Binary_string> = {<Static_binary_string> = {<Sql_alloc> = {dummy_for_valgrind = false}, Ptr = 0x7ffe64097688 "t12", str_length = 3}, Alloced_length = 8, extra_alloc = 0, alloced = true, thread_specific = false}, <No data fields>}

(gdb) p table->s->table_name

  $21 = {str = 0x7ffe64093b15 "t12", length = 3}

create table ten(a int primary key);

insert into ten values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);

create table one_k(a int primary key);

insert into one_k select A.a + B.a* 10 + C.a * 100 from ten A, ten B, ten C;

create table t10 (a int, b int, key(a));

insert into t10 select a,a from one_k;

create table t11 like t10;

insert into t11 select * from t10;

create table t12 like t10;

create table t13 like t10;

create table t14 like t10;

insert into t12 select * from t10;

insert into t13 select * from t10;

insert into t14 select * from t10;

explain select * from one_k where a in (select t10.b from t10, t11, t12, t13, t14 where t11.a=t10.b+1 and t12.a=t10.b and t13.a=t10.b and t14.a=t10.b);

explain select * from one_k where a in (select t10.b from t10, t11, t12, t13, t14 where t11.a=t10.b+1 and t12.a=t10.b and t13.a=t10.b and t14.a=t10.b);