Assertion `info->key_del_used == 0' failed in maria_close with limited tmp space

--source include/have_sequence.inc

CREATE TABLE t1 (a varchar(1024));

INSERT INTO t1 VALUES ('this'),('is'),('just'),('a'),('filling'),('for'),(REPEAT('a',500));

SET max_tmp_session_space_usage = 1024*1024, max_heap_table_size= 4*1024*1024;

SELECT DISTINCT a, seq FROM t1 JOIN seq_1_to_600;

# Cleanup

DROP TABLE t1;

mariadbd: /data/bld/bb-11.5-monty-debug/storage/maria/ma_close.c:42: maria_close: Assertion `info->key_del_used == 0' failed.

240428  3:23:05 [ERROR] mysqld got signal 6 ;

#9  0x00007fa8ae453e32 in __GI___assert_fail (assertion=0x55eb6c76b74b "info->key_del_used == 0", file=0x55eb6c76b6d0 "/data/bld/bb-11.5-monty-debug/storage/maria/ma_close.c", line=42, function=0x55eb6c76bb58 <__PRETTY_FUNCTION__.1> "maria_close") at ./assert/assert.c:101

#10 0x000055eb6bce907b in maria_close (info=0x7fa898f1e978) at /data/bld/bb-11.5-monty-debug/storage/maria/ma_close.c:42

#11 0x000055eb6bcf35c9 in ha_maria::close (this=0x7fa8980882e0) at /data/bld/bb-11.5-monty-debug/storage/maria/ha_maria.cc:1290

#12 0x000055eb6bacee8b in handler::ha_close (this=0x7fa8980882e0) at /data/bld/bb-11.5-monty-debug/sql/handler.cc:3605

#13 0x000055eb6bcf8b66 in ha_maria::drop_table (this=0x7fa8980882e0, name=0x7fa8980685e0 "/mnt8t/bld/bb-11.5-monty-debug/mysql-test/var/tmp/mysqld.1/#sql-temptable-1ec6b-4-f") at /data/bld/bb-11.5-monty-debug/storage/maria/ha_maria.cc:2950

#14 0x000055eb6b7514ec in create_internal_tmp_table_from_heap (thd=0x7fa898000dc8, table=0x7fa898067860, start_recinfo=0x7fa898068410, recinfo=0x7fa898067018, error=135, ignore_last_dupp_key_error=true, is_duplicate=0x7fa8a8b93c73) at /data/bld/bb-11.5-monty-debug/sql/sql_select.cc:22819

#15 0x000055eb6b757922 in end_write (join=0x7fa8980191a0, join_tab=0x7fa898065f68, end_of_records=false) at /data/bld/bb-11.5-monty-debug/sql/sql_select.cc:25203

#16 0x000055eb6b76c3fa in AGGR_OP::put_record (this=0x7fa898067170, end_of_records=false) at /data/bld/bb-11.5-monty-debug/sql/sql_select.cc:32500

#17 0x000055eb6b774d7d in AGGR_OP::put_record (this=0x7fa898067170) at /data/bld/bb-11.5-monty-debug/sql/sql_select.h:1186

#18 0x000055eb6b752d44 in sub_select_postjoin_aggr (join=0x7fa8980191a0, join_tab=0x7fa898065f68, end_of_records=false) at /data/bld/bb-11.5-monty-debug/sql/sql_select.cc:23298

#19 0x000055eb6b902e13 in JOIN_CACHE::generate_full_extensions (this=0x7fa898066eb0, rec_ptr=0x7fa898069edb "\376\001") at /data/bld/bb-11.5-monty-debug/sql/sql_join_cache.cc:2540

#20 0x000055eb6b902acd in JOIN_CACHE::join_matching_records (this=0x7fa898066eb0, skip_last=false) at /data/bld/bb-11.5-monty-debug/sql/sql_join_cache.cc:2432

#21 0x000055eb6b902241 in JOIN_CACHE::join_records (this=0x7fa898066eb0, skip_last=false) at /data/bld/bb-11.5-monty-debug/sql/sql_join_cache.cc:2182

#22 0x000055eb6b752e75 in sub_select_cache (join=0x7fa8980191a0, join_tab=0x7fa898065af8, end_of_records=true) at /data/bld/bb-11.5-monty-debug/sql/sql_select.cc:23357

#23 0x000055eb6b753146 in sub_select (join=0x7fa8980191a0, join_tab=0x7fa898065688, end_of_records=true) at /data/bld/bb-11.5-monty-debug/sql/sql_select.cc:23547

#24 0x000055eb6b752675 in do_select (join=0x7fa8980191a0, procedure=0x0) at /data/bld/bb-11.5-monty-debug/sql/sql_select.cc:23127

#25 0x000055eb6b71e2fb in JOIN::exec_inner (this=0x7fa8980191a0) at /data/bld/bb-11.5-monty-debug/sql/sql_select.cc:4988

#26 0x000055eb6b71d309 in JOIN::exec (this=0x7fa8980191a0) at /data/bld/bb-11.5-monty-debug/sql/sql_select.cc:4774

#27 0x000055eb6b71ed96 in mysql_select (thd=0x7fa898000dc8, tables=0x7fa898016000, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2164525825, result=0x7fa898019178, unit=0x7fa8980052b0, select_lex=0x7fa898015890) at /data/bld/bb-11.5-monty-debug/sql/sql_select.cc:5304

#28 0x000055eb6b70d009 in handle_select (thd=0x7fa898000dc8, lex=0x7fa8980051d0, result=0x7fa898019178, setup_tables_done_option=0) at /data/bld/bb-11.5-monty-debug/sql/sql_select.cc:630

#29 0x000055eb6b6b0891 in execute_sqlcom_select (thd=0x7fa898000dc8, all_tables=0x7fa898016000) at /data/bld/bb-11.5-monty-debug/sql/sql_parse.cc:6101

#30 0x000055eb6b6a8672 in mysql_execute_command (thd=0x7fa898000dc8, is_called_from_prepared_stmt=false) at /data/bld/bb-11.5-monty-debug/sql/sql_parse.cc:3948

#31 0x000055eb6b6b5856 in mysql_parse (thd=0x7fa898000dc8, rawbuf=0x7fa8980157d0 "SELECT DISTINCT a, seq FROM t1 JOIN seq_1_to_600", length=48, parser_state=0x7fa8a8b95330) at /data/bld/bb-11.5-monty-debug/sql/sql_parse.cc:7821

#32 0x000055eb6b6a1ee4 in dispatch_command (command=COM_QUERY, thd=0x7fa898000dc8, packet=0x7fa89800bd39 "", packet_length=48, blocking=true) at /data/bld/bb-11.5-monty-debug/sql/sql_parse.cc:1893

#33 0x000055eb6b6a083d in do_command (thd=0x7fa898000dc8, blocking=true) at /data/bld/bb-11.5-monty-debug/sql/sql_parse.cc:1406

#34 0x000055eb6b89ffcd in do_handle_one_connection (connect=0x55eb6e6b8f98, put_in_cache=true) at /data/bld/bb-11.5-monty-debug/sql/sql_connect.cc:1439

#35 0x000055eb6b89fd42 in handle_one_connection (arg=0x55eb6e6fc9d8) at /data/bld/bb-11.5-monty-debug/sql/sql_connect.cc:1341

#36 0x000055eb6bdeee54 in pfs_spawn_thread (arg=0x55eb6e6b8b08) at /data/bld/bb-11.5-monty-debug/storage/perfschema/pfs.cc:2201

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

#38 0x00007fa8ae52861c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81