[#MDEV-32982] Assertion `0' failed in Delayed_prelocking_strategy::handle

CREATE TABLE t (a INT) ENGINE=MyISAM;

CREATE VIEW v AS SELECT * FROM t;

PREPARE stmt FROM " INSERT DELAYED INTO v VALUES (NULL)";

DROP VIEW v;

CREATE TABLE v (a INT) ENGINE=MyISAM;

EXECUTE stmt;

# Cleanup

DROP TABLE v, t;

10.4 ba94778d2c438d4c0f93ce031e504f7d78e895e1
mysqld: /data/bld/10.4-asan/sql/sql_insert.cc:2986: virtual bool Delayed_prelocking_strategy::handle_view(THD, Query_tables_list, TABLE_LIST, bool): Assertion `0' failed.
231210 17:03:07 [ERROR] mysqld got signal 6 ;

#9 0x00007f3814f74e32 in __GI___assert_fail (assertion=0x55cbd22f2c20 "0", file=0x55cbd22f1060 "/data/bld/10.4-asan/sql/sql_insert.cc", line=2986, function=0x55cbd22f2d00 "virtual bool Delayed_prelocking_strategy::handle_view(THD, Query_tables_list, TABLE_LIST, bool)") at ./assert/assert.c:101
#10 0x000055cbd01b4a1e in Delayed_prelocking_strategy::handle_view (this=0x7f380b314b30, thd=0x62c000068228, prelocking_ctx=0x62c00006c098, table_list=0x62c00006ea20, need_prelocking=0x7f380b3145e0) at /data/bld/10.4-asan/sql/sql_insert.cc:2986
#11 0x000055cbd00d4985 in open_and_process_table (thd=0x62c000068228, tables=0x62c00006ea20, counter=0x7f380b314930, flags=65537, prelocking_strategy=0x7f380b314b30, has_prelocking_list=false, ot_ctx=0x7f380b314820) at /data/bld/10.4-asan/sql/sql_base.cc:4010
#12 0x000055cbd00d6a64 in open_tables (thd=0x62c000068228, options=..., start=0x7f380b314940, counter=0x7f380b314930, flags=65537, prelocking_strategy=0x7f380b314b30) at /data/bld/10.4-asan/sql/sql_base.cc:4399
#13 0x000055cbd00dbb7f in open_and_lock_tables (thd=0x62c000068228, options=..., tables=0x62c00006ea20, derived=false, flags=65537, prelocking_strategy=0x7f380b314b30) at /data/bld/10.4-asan/sql/sql_base.cc:5346
#14 0x000055cbd00bf493 in open_and_lock_tables (thd=0x62c000068228, tables=0x62c00006ea20, derived=false, flags=65537, prelocking_strategy=0x7f380b314b30) at /data/bld/10.4-asan/sql/sql_base.h:270
#15 0x000055cbd00daa9f in open_n_lock_single_table (thd=0x62c000068228, table_l=0x62c00006ea20, lock_type=TL_WRITE_DELAYED, flags=65537, prelocking_strategy=0x7f380b314b30) at /data/bld/10.4-asan/sql/sql_base.cc:5189
#16 0x000055cbd01b4aff in Delayed_insert::open_and_lock_table (this=0x62c000068208) at /data/bld/10.4-asan/sql/sql_insert.cc:3011
#17 0x000055cbd01b5499 in handle_delayed_insert (arg=0x62c000068208) at /data/bld/10.4-asan/sql/sql_insert.cc:3114
#18 0x000055cbd12ba9fe in pfs_spawn_thread (arg=0x615000010e88) at /data/bld/10.4-asan/storage/perfschema/pfs.cc:1869
#19 0x00007f3814fc9044 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
#20 0x00007f381504961c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81

[MDEV-32982] Assertion `0' failed in Delayed_prelocking_strategy::handle_view Created: 2023-12-10 Updated: 2023-12-10
Status:	Open
Project:	MariaDB Server
Component/s:	Data Manipulation - Insert, Prepared Statements, Views
Affects Version/s:	10.4, 10.5, 10.6, 10.11, 11.0, 11.1, 11.2, 11.3
Fix Version/s:	10.4, 10.5, 10.6, 10.11, 11.0, 11.1, 11.2, 11.3

[MDEV-32982] Assertion `0' failed in Delayed_prelocking_strategy::handle_view Created: 2023-12-10 Updated: 2023-12-10