[MDEV-15402] Assertion `table' failed in mysql_delete on attempt to delete history from view Created: 2018-02-23  Updated: 2018-02-24  Resolved: 2018-02-24

Status: Closed
Project: MariaDB Server
Component/s: Versioned Tables, Views
Affects Version/s: 10.3
Fix Version/s: 10.3.5

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: None


 Description   

Slightly modified reincarnation of MDEV-14684

CREATE OR REPLACE TABLE t (i INT);
CREATE OR REPLACE VIEW v AS SELECT * FROM t;
LOCK TABLE v WRITE;
DELETE HISTORY FROM v BEFORE system_time NOW(6);
 
# Cleanup
DROP VIEW v;
DROP TABLE t;

bb-10.3-release 7bed4877cb

mysqld: /data/src/bb-10.3-release/sql/sql_delete.cc:312: bool mysql_delete(THD*, TABLE_LIST*, COND*, SQL_I_List<st_order>*, ha_rows, ulonglong, select_result*): Assertion `table' failed.
180224  0:41:00 [ERROR] mysqld got signal 6 ;
 
#7  0x00007fb76fdcdee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
#8  0x000055e32a936ee8 in mysql_delete (thd=0x7fb758000b00, table_list=0x7fb758014da0, conds=0x0, order_list=0x7fb758005280, limit=18446744073709551615, options=0, result=0x0) at /data/src/bb-10.3-release/sql/sql_delete.cc:312
#9  0x000055e32a4a0e2f in mysql_execute_command (thd=0x7fb758000b00) at /data/src/bb-10.3-release/sql/sql_parse.cc:4902
#10 0x000055e32a4aa926 in mysql_parse (thd=0x7fb758000b00, rawbuf=0x7fb758014c98 "DELETE HISTORY FROM v BEFORE system_time NOW(6)", length=47, parser_state=0x7fb76a03c5d0, is_com_multi=false, is_next_command=false) at /data/src/bb-10.3-release/sql/sql_parse.cc:7980
#11 0x000055e32a4980d5 in dispatch_command (command=COM_QUERY, thd=0x7fb758000b00, packet=0x7fb75808fac1 "DELETE HISTORY FROM v BEFORE system_time NOW(6)", packet_length=47, is_com_multi=false, is_next_command=false) at /data/src/bb-10.3-release/sql/sql_parse.cc:1825
#12 0x000055e32a496b14 in do_command (thd=0x7fb758000b00) at /data/src/bb-10.3-release/sql/sql_parse.cc:1370
#13 0x000055e32a5fb2bf in do_handle_one_connection (connect=0x55e32e2f2be0) at /data/src/bb-10.3-release/sql/sql_connect.cc:1402
#14 0x000055e32a5fb04c in handle_one_connection (arg=0x55e32e2f2be0) at /data/src/bb-10.3-release/sql/sql_connect.cc:1308
#15 0x000055e32aa9cf1f in pfs_spawn_thread (arg=0x55e32e306480) at /data/src/bb-10.3-release/storage/perfschema/pfs.cc:1862
#16 0x00007fb771aa4494 in start_thread (arg=0x7fb76a03d700) at pthread_create.c:333
#17 0x00007fb76fe8a93f in clone () from /lib/x86_64-linux-gnu/libc.so.6

Not reproducible (yet) on main 10.3 2732fcc608.
No visible effect on a non-debug build.


Generated at Thu Feb 08 08:21:01 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.