Test failure: ./mtr --no-reorder main.log_slow_debug main.subselect

./mtr --no-reorder main.log_slow_debug main.subselect

main.log_slow_debug                      [ pass ]     75

main.subselect                           [ fail ]

        Test ended at 2023-10-19 08:03:36

CURRENT_TEST: main.subselect

/dev/shm/10.4/client//mysqltest: Error on delete of '/dev/shm/10.4/mysql-test/var/tmp/subselect.out.file.1' (Errcode: 2 "No such file or directory")

mysqltest: At line 5993: query 'Select 

(Select Sum(`TestCase`.Revenue) From mysql.slow_log E           

Where TestCase.TemplateID not in (Select 1 from mysql.slow_log where 2=2)

) As `ControlRev`

From 

(Select  3 as Revenue, 4 as TemplateID) As `TestCase` 

Group By  TestCase.Revenue, TestCase.TemplateID' failed: 1242: Subquery returns more than 1 row

The result from queries just before the failure was:

< snip >

2	SUBQUERY	t2	ref	b	b	5	test.t1.a	2Using index

DROP TABLE t1,t2;

#

# MDEV-5991: crash in Item_field::used_tables

#

create table t1 (c int);

select exists(select 1 from t1 group by `c` in (select `c` from t1));

exists(select 1 from t1 group by `c` in (select `c` from t1))

0

drop table t1;

#

# MDEV-7565: Server crash with Signal 6 (part 2)

#

Select 

(Select Sum(`TestCase`.Revenue) From mysql.slow_log E           

Where TestCase.TemplateID not in (Select 1 from mysql.slow_log where 2=2)

) As `ControlRev`

From 

(Select  3 as Revenue, 4 as TemplateID) As `TestCase` 

Group By  TestCase.Revenue, TestCase.TemplateID;

More results from queries before failure can be found in /dev/shm/10.4/mysql-test/var/log/subselect.log

 - saving '/dev/shm/10.4/mysql-test/var/log/main.subselect/' to '/dev/shm/10.4/mysql-test/var/log/main.subselect/'