Assertion failure in Table_triggers_list::add_tables_and_routines_for_triggers upon attempt to insert DEFAULT into non-insertable view

CREATE TABLE t (f INT);

CREATE ALGORITHM=TEMPTABLE VIEW v AS SELECT * FROM t;

CREATE TRIGGER tr BEFORE UPDATE ON t FOR EACH ROW SET @a=1;

--error ER_NON_INSERTABLE_TABLE

INSERT INTO v VALUES (DEFAULT);

DROP VIEW v;

DROP TABLE t;

mariadbd: /data/bld/10.6-asan-ubsan/sql/sql_trigger.cc:2537: bool Table_triggers_list::add_tables_and_routines_for_triggers(THD*, Query_tables_list*, TABLE_LIST*): Assertion `static_cast<int>(table_list->lock_type) >= static_cast<int>(TL_WRITE_ALLOW_WRITE)' failed.

250723 18:15:10 [ERROR] /share8t/bld/10.6-asan-ubsan/sql/mariadbd got signal 6 ;

#10 0x00007fde1de53eb2 in __GI___assert_fail (assertion=0x5615689fd4a0 "static_cast<int>(table_list->lock_type) >= static_cast<int>(TL_WRITE_ALLOW_WRITE)", file=0x5615689fb2a0 "/data/bld/10.6-asan-ubsan/sql/sql_trigger.cc", line=2537, function=0x5615689fd400 "bool Table_triggers_list::add_tables_and_routines_for_triggers(THD*, Query_tables_list*, TABLE_LIST*)") at ./assert/assert.c:101

#11 0x00005615655e6e73 in Table_triggers_list::add_tables_and_routines_for_triggers (this=this@entry=0x625000244c10, thd=thd@entry=0x62b00007e218, prelocking_ctx=prelocking_ctx@entry=0x62b000082540, table_list=table_list@entry=0x62d00005e198) at /data/bld/10.6-asan-ubsan/sql/sql_trigger.cc:2537

#12 0x0000561564d88f61 in DML_prelocking_strategy::handle_table (this=<optimized out>, thd=0x62b00007e218, prelocking_ctx=<optimized out>, table_list=0x62d00005e198, need_prelocking=<optimized out>) at /data/bld/10.6-asan-ubsan/sql/sql_base.cc:4907

#13 0x0000561564d851b1 in extend_table_list (thd=thd@entry=0x62b00007e218, tables=tables@entry=0x62d00005e198, prelocking_strategy=prelocking_strategy@entry=0x7fde13e9a860, has_prelocking_list=has_prelocking_list@entry=false) at /data/bld/10.6-asan-ubsan/sql/sql_base.cc:3695

#14 0x0000561564d87d6d in open_and_process_table (thd=thd@entry=0x62b00007e218, tables=tables@entry=0x62d00005e198, counter=counter@entry=0x7fde13e9a730, flags=flags@entry=0, prelocking_strategy=prelocking_strategy@entry=0x7fde13e9a860, has_prelocking_list=has_prelocking_list@entry=false, ot_ctx=<optimized out>) at /data/bld/10.6-asan-ubsan/sql/sql_base.cc:4001

#15 0x0000561564db9089 in open_tables (thd=thd@entry=0x62b00007e218, options=..., start=start@entry=0x7fde13e9a740, counter=counter@entry=0x7fde13e9a730, flags=flags@entry=0, prelocking_strategy=prelocking_strategy@entry=0x7fde13e9a860) at /data/bld/10.6-asan-ubsan/sql/sql_base.cc:4425

#16 0x0000561564dbc6da in open_and_lock_tables (thd=thd@entry=0x62b00007e218, options=..., tables=tables@entry=0x62d00005a558, derived=derived@entry=true, flags=flags@entry=0, prelocking_strategy=prelocking_strategy@entry=0x7fde13e9a860) at /data/bld/10.6-asan-ubsan/sql/sql_base.cc:5414

#17 0x0000561564c6d77c in open_and_lock_tables (thd=thd@entry=0x62b00007e218, tables=tables@entry=0x62d00005a558, derived=derived@entry=true, flags=flags@entry=0) at /data/bld/10.6-asan-ubsan/sql/sql_base.h:517

#18 0x0000561564f59665 in mysql_insert (thd=thd@entry=0x62b00007e218, table_list=<optimized out>, fields=..., values_list=..., update_fields=..., update_values=..., duplic=<optimized out>, ignore=<optimized out>, result=<optimized out>) at /data/bld/10.6-asan-ubsan/sql/sql_insert.cc:765

#19 0x00005615650ed13a in mysql_execute_command (thd=thd@entry=0x62b00007e218, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /data/bld/10.6-asan-ubsan/sql/sql_parse.cc:4634

#20 0x0000561565107cf2 in mysql_parse (thd=thd@entry=0x62b00007e218, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7fde13e9bac0) at /data/bld/10.6-asan-ubsan/sql/sql_parse.cc:8200

#21 0x0000561565110fc2 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x62b00007e218, packet=packet@entry=0x62900024e219 "INSERT INTO v VALUES (DEFAULT)", packet_length=packet_length@entry=30, blocking=blocking@entry=true) at /data/bld/10.6-asan-ubsan/sql/sql_parse.cc:1908

#22 0x000056156511dc14 in do_command (thd=thd@entry=0x62b00007e218, blocking=blocking@entry=true) at /data/bld/10.6-asan-ubsan/sql/sql_parse.cc:1421

#23 0x000056156589f6dc in do_handle_one_connection (connect=<optimized out>, connect@entry=0x608000002f38, put_in_cache=put_in_cache@entry=true) at /data/bld/10.6-asan-ubsan/sql/sql_connect.cc:1386

#24 0x00005615658a0839 in handle_one_connection (arg=0x608000002f38) at /data/bld/10.6-asan-ubsan/sql/sql_connect.cc:1298

#25 0x00005615672d1a89 in pfs_spawn_thread (arg=0x617000005b98) at /data/bld/10.6-asan-ubsan/storage/perfschema/pfs.cc:2201

#26 0x00007fde1dea81c4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442

commit 1c7685f5fc5693312a7244f7575584ef59f096a4 (HEAD)

Commit:     Sergei Golubchik

CommitDate: Wed Jul 9 17:32:37 2025 +0200

    bugfix: nextval() in default, and UPDATE SET x=DEFAULT