CREATE TABLE t1 ( a int, d int)engine=innodb;

INSERT INTO t1 VALUES (1,2),(3,4); #not important

CREATE VIEW v1 AS select d from t1  order by a ;

UPDATE v1 SET d= d + 1 WHERE rownum() > 1 ;

Version: '10.6.13-MariaDB-debug-log' 

230502 13:16:58 [ERROR] mysqld got signal 11 ;

Server version: 10.6.13-MariaDB-debug-log source revision: 5f3a4beb9dabbb6e531f48661907b73100bc4ef3

sql/signal_handler.cc:241(handle_fatal_signal)[0x55b9257e770e]

sigaction.c:0(__restore_rt)[0x7fcf38c78420]

heap/hp_info.c:34(heap_info)[0x55b92622ce33]

heap/ha_heap.cc:372(ha_heap::info(unsigned int))[0x55b92621e295]

sql/sql_update.cc:573(mysql_update(THD*, TABLE_LIST*, List<Item>&, List<Item>&, Item*, unsigned int, st_order*, unsigned long long, bool, unsigned long long*, unsigned long long*))[0x55b925291125]

sql/sql_parse.cc:4413(mysql_execute_command(THD*, bool))[0x55b924f60666]

sql/sql_parse.cc:8036(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x55b924f7a1b9]

sql/sql_parse.cc:1898(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x55b924f5003a]

sql/sql_parse.cc:1409(do_command(THD*, bool))[0x55b924f4cd85]

sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0x55b9253c9df1]

sql/sql_connect.cc:1320(handle_one_connection)[0x55b9253c974e]

perfschema/pfs.cc:2203(pfs_spawn_thread)[0x55b926061d3c]

nptl/pthread_create.c:478(start_thread)[0x7fcf38c6c609]

Query (0x62b0000c42a8): UPDATE v1 SET d= d + 1 WHERE rownum() > 1