Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
11.4, 11.8
-
None
Description
CREATE TABLE t1 (a INT); |
CREATE VIEW v1 AS SELECT * FROM t1; |
CREATE VIEW v2 AS SELECT * FROM (WITH cte AS (SELECT COUNT(*) FROM v1) SELECT * FROM cte) sq; |
--error ER_NON_UPDATABLE_TABLE
|
DELETE FROM v2; |
|
DROP VIEW v2; |
DROP VIEW v1; |
DROP TABLE t1; |
11.4 e176066a9e02cf2bdedf9e79fb150029dde430f6 |
mariadbd: /data/bld/11.4-asan/sql/sql_select.cc:23496: void free_tmp_table(THD*, TABLE*): Assertion `entry->pos_in_table_list->table == entry' failed.
|
250411 0:16:30 [ERROR] /share8t/bld/11.4-asan/sql/mariadbd got signal 6 ;
|
|
#9 0x00007f9f28e53eb2 in __GI___assert_fail (assertion=0x558a12cb80c0 "entry->pos_in_table_list->table == entry", file=0x558a12ca9780 "/data/bld/11.4-asan/sql/sql_select.cc", line=23496, function=0x558a12cb8120 "void free_tmp_table(THD*, TABLE*)") at ./assert/assert.c:101
|
#10 0x0000558a10aedce5 in free_tmp_table (thd=0x62c0000b0218, entry=0x62d000514438) at /data/bld/11.4-asan/sql/sql_select.cc:23496
|
#11 0x0000558a107867eb in close_thread_tables (thd=0x62c0000b0218) at /data/bld/11.4-asan/sql/sql_base.cc:917
|
#12 0x0000558a10785d74 in close_thread_tables_for_query (thd=0x62c0000b0218) at /data/bld/11.4-asan/sql/sql_base.cc:815
|
#13 0x0000558a1095abdb in mysql_execute_command (thd=0x62c0000b0218, is_called_from_prepared_stmt=false) at /data/bld/11.4-asan/sql/sql_parse.cc:5968
|
#14 0x0000558a109675b8 in mysql_parse (thd=0x62c0000b0218, rawbuf=0x62d0002d0438 "DELETE FROM v2", length=14, parser_state=0x7f9f1953fa90) at /data/bld/11.4-asan/sql/sql_parse.cc:7907
|
#15 0x0000558a1093e61c in dispatch_command (command=COM_QUERY, thd=0x62c0000b0218, packet=0x629000253219 "DELETE FROM v2", packet_length=14, blocking=true) at /data/bld/11.4-asan/sql/sql_parse.cc:1904
|
#16 0x0000558a1093b354 in do_command (thd=0x62c0000b0218, blocking=true) at /data/bld/11.4-asan/sql/sql_parse.cc:1417
|
#17 0x0000558a10e20689 in do_handle_one_connection (connect=0x608000003b38, put_in_cache=true) at /data/bld/11.4-asan/sql/sql_connect.cc:1408
|
#18 0x0000558a10e201e8 in handle_one_connection (arg=0x608000003ab8) at /data/bld/11.4-asan/sql/sql_connect.cc:1320
|
#19 0x0000558a11aa281a in pfs_spawn_thread (arg=0x617000005b98) at /data/bld/11.4-asan/storage/perfschema/pfs.cc:2201
|
#20 0x00007f9f28ea81c4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
#21 0x00007f9f28f2885c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
|
On a non-debug build DELETE ends with ER_NON_UPDATABLE_TABLE, as it apparently should.
The failure is reproducible on 11.4 starting at least from the creation of 11.4 branch, but isn't reproducible on 10.11.