Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.4(EOL), 10.5, 10.6, 10.11, 11.0(EOL), 11.1(EOL), 11.2(EOL), 11.3(EOL)
-
None
Description
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
|