Server crashes when a multi-table delete statement contains a VIEW with an ORDER BY clause by any of the built-in functions

CREATE OR REPLACE VIEW v1 AS SELECT * FROM information_schema.tables ORDER BY LEFT(table_name,100);

CREATE OR REPLACE TABLE t1 (a CHAR(1) KEY) ;

DELETE FROM t1 USING v1,t1;

Core was generated by `/test/MD300424-mariadb-10.6.18-linux-x86_64-opt/bin/mariadbd --no-defaults --ma'.

Program terminated with signal SIGSEGV, Segmentation fault.

#0  0x00005564a337eadb in Item_field::used_tables (this=0x14f0bc029158)at /test/10.6_opt/sql/item.cc:3527

warning: Source file is more recent than executable.

3527	  if (field->table->const_table)

[Current thread is 1 (Thread 0x14f1000de700 (LWP 2392129))]

(gdb) bt

#0  0x00005564a337eadb in Item_field::used_tables (this=0x14f0bc029158) at /test/10.6_opt/sql/item.cc:3527

#1  0x00005564a30b9252 in Used_tables_and_const_cache::used_tables_and_const_cache_join (this=0x14f0bc029338, this=0x14f0bc029338, item=0x14f0bc029158) at /test/10.6_opt/sql/item.h:5376

#2  Used_tables_and_const_cache::used_tables_and_const_cache_update_and_join (item=0x14f0bc029158, this=0x14f0bc029338) at /test/10.6_opt/sql/item.h:5376

#3  Used_tables_and_const_cache::used_tables_and_const_cache_update_and_join (argv=<optimized out>, argc=<optimized out>, this=0x14f0bc029338) at /test/10.6_opt/sql/item.h:5387

#4  Item_func::update_used_tables (this=0x14f0bc0292a8) at /test/10.6_opt/sql/item_func.h:215

#5  0x00005564a30de2c0 in st_select_lex::update_used_tables (this=0x14f0bc005680) at /test/10.6_opt/sql/sql_lex.cc:5481

#6  0x00005564a317160a in JOIN::optimize_inner (this=0x14f0bc02d5b8) at /test/10.6_opt/sql/sql_select.cc:2106

#7  0x00005564a31753b0 in JOIN::optimize (this=this@entry=0x14f0bc02d5b8) at /test/10.6_opt/sql/sql_select.cc:1888

#8  0x00005564a3175487 in mysql_select (thd=thd@entry=0x14f0bc000c58, tables=0x14f0bc0111c0, fields=@0x14f0bc005938: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x14f0bc0120a0, last = 0x14f0bc0120a0, elements = 1}, <No data fields>}, conds=conds@entry=0x0, og_num=og_num@entry=0, order=order@entry=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=<optimized out>, result=0x14f0bc02d550, unit=0x14f0bc004e60, select_lex=0x14f0bc005680) at /test/10.6_opt/sql/sql_select.cc:5127

#9  0x00005564a310d2df in mysql_execute_command (thd=0x14f0bc000c58, is_called_from_prepared_stmt=<optimized out>) at /test/10.6_opt/sql/sql_parse.cc:4942

#10 0x00005564a30fb436 in mysql_parse (thd=0x14f0bc000c58, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>) at /test/10.6_opt/sql/sql_parse.cc:8146

#11 0x00005564a3107eed in dispatch_command (command=COM_QUERY, thd=0x14f0bc000c58, packet=<optimized out>, packet_length=<optimized out>, blocking=<optimized out>) at /test/10.6_opt/sql/sql_class.h:1416

#12 0x00005564a310a26e in do_command (thd=0x14f0bc000c58, blocking=blocking@entry=true) at /test/10.6_opt/sql/sql_parse.cc:1409

#13 0x00005564a3223c37 in do_handle_one_connection (connect=<optimized out>, put_in_cache=true) at /test/10.6_opt/sql/sql_connect.cc:1415

#14 0x00005564a3223f7d in handle_one_connection (arg=arg@entry=0x5564a5384568) at /test/10.6_opt/sql/sql_connect.cc:1317

#15 0x00005564a35da21c in pfs_spawn_thread (arg=0x5564a532d698) at /test/10.6_opt/storage/perfschema/pfs.cc:2201

#16 0x000014f1016ba609 in start_thread (arg=<optimized out>) at pthread_create.c:477

#17 0x000014f1012a6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95