CREATE TABLE t (pk INT PRIMARY KEY);

INSERT INTO t VALUES (1),(2); # Optional, fails either way

PREPARE stmt FROM ' SELECT * FROM t WHERE (1,2) IN (SELECT t1.pk, t2.pk FROM t t1 STRAIGHT_JOIN t t2)';

EXECUTE stmt;

EXECUTE stmt;

# Cleanup

DROP TABLE t;

mariadbd: /data/bld/10.5-asan/mysys/my_alloc.c:212: alloc_root: Assertion `(mem_root->flags & 4) == 0' failed.

241010  0:35:49 [ERROR] mysqld got signal 6 ;

#9  0x00007f20fe653e32 in __GI___assert_fail (assertion=0x56202ec85d60 "(mem_root->flags & 4) == 0", file=0x56202ec85a60 "/data/bld/10.5-asan/mysys/my_alloc.c", line=212, function=0x56202ec86080 <__PRETTY_FUNCTION__.0> "alloc_root") at ./assert/assert.c:101

#10 0x000056202d8b5fd7 in alloc_root (mem_root=0x61900009e618, length=16) at /data/bld/10.5-asan/mysys/my_alloc.c:212

#11 0x000056202b76b872 in Sql_alloc::operator new (size=16, mem_root=0x61900009e618) at /data/bld/10.5-asan/sql/sql_alloc.h:39

#12 0x000056202b76c1a4 in base_list::push_back (this=0x62b00009c160, info=0x62b00009d808, mem_root=0x61900009e618) at /data/bld/10.5-asan/sql/sql_list.h:195

#13 0x000056202b913f03 in List<TABLE_LIST>::push_back (this=0x62b00009c160, a=0x62b00009d808, mem_root=0x61900009e618) at /data/bld/10.5-asan/sql/sql_list.h:505

#14 0x000056202bfc0ab2 in pull_out_semijoin_tables (join=0x62b000038650) at /data/bld/10.5-asan/sql/opt_subselect.cc:2405

#15 0x000056202bb636fe in make_join_statistics (join=0x62b000038650, tables_list=..., keyuse_array=0x62b000038948) at /data/bld/10.5-asan/sql/sql_select.cc:5774

#16 0x000056202bb41072 in JOIN::optimize_inner (this=0x62b000038650) at /data/bld/10.5-asan/sql/sql_select.cc:2416

#17 0x000056202bb3a1ef in JOIN::optimize (this=0x62b000038650) at /data/bld/10.5-asan/sql/sql_select.cc:1765

#18 0x000056202bb5b2b2 in mysql_select (thd=0x62b000069218, tables=0x62b00009c610, fields=..., conds=0x62b000038380, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2201171004160, result=0x62b00009fa90, unit=0x62b00009a310, select_lex=0x62b00009bf80) at /data/bld/10.5-asan/sql/sql_select.cc:4902

#19 0x000056202bb2b7a2 in handle_select (thd=0x62b000069218, lex=0x62b00009a248, result=0x62b00009fa90, setup_tables_done_option=0) at /data/bld/10.5-asan/sql/sql_select.cc:449

#20 0x000056202ba922fd in execute_sqlcom_select (thd=0x62b000069218, all_tables=0x62b00009c610) at /data/bld/10.5-asan/sql/sql_parse.cc:6438

#21 0x000056202ba8073f in mysql_execute_command (thd=0x62b000069218) at /data/bld/10.5-asan/sql/sql_parse.cc:4030

#22 0x000056202baf3426 in Prepared_statement::execute (this=0x61900009e298, expanded_query=0x7f20f4ecbd10, open_cursor=false) at /data/bld/10.5-asan/sql/sql_prepare.cc:5131

#23 0x000056202baee56d in Prepared_statement::execute_loop (this=0x61900009e298, expanded_query=0x7f20f4ecbd10, open_cursor=false, packet=0x0, packet_end=0x0) at /data/bld/10.5-asan/sql/sql_prepare.cc:4553

#24 0x000056202bae7fa7 in mysql_sql_stmt_execute (thd=0x62b000069218) at /data/bld/10.5-asan/sql/sql_prepare.cc:3594

#25 0x000056202ba80784 in mysql_execute_command (thd=0x62b000069218) at /data/bld/10.5-asan/sql/sql_parse.cc:4046

#26 0x000056202ba9d10b in mysql_parse (thd=0x62b000069218, rawbuf=0x62b000038238 "EXECUTE stmt", length=12, parser_state=0x7f20f4eccc10, is_com_multi=false, is_next_command=false) at /data/bld/10.5-asan/sql/sql_parse.cc:8236

#27 0x000056202ba723f1 in dispatch_command (command=COM_QUERY, thd=0x62b000069218, packet=0x629000235219 "EXECUTE stmt", packet_length=12, is_com_multi=false, is_next_command=false) at /data/bld/10.5-asan/sql/sql_parse.cc:1892

#28 0x000056202ba6ed84 in do_command (thd=0x62b000069218) at /data/bld/10.5-asan/sql/sql_parse.cc:1376

#29 0x000056202bec8996 in do_handle_one_connection (connect=0x608000002ab8, put_in_cache=true) at /data/bld/10.5-asan/sql/sql_connect.cc:1417

#30 0x000056202bec8359 in handle_one_connection (arg=0x608000002a38) at /data/bld/10.5-asan/sql/sql_connect.cc:1319

#31 0x000056202cb27004 in pfs_spawn_thread (arg=0x615000005318) at /data/bld/10.5-asan/storage/perfschema/pfs.cc:2201

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

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