$ ./mtr main.delete --view

Logging: ./mtr  main.delete --view

MariaDB Version 10.4.29-MariaDB-debug

==============================================================================

TEST                                      RESULT   TIME (ms) or COMMENT

--------------------------------------------------------------------------

main.delete                              [ fail ]

        Test ended at 2023-02-17 09:40:49

CURRENT_TEST: main.delete

mysqltest: At line 607: query 'select * from t1

where $c' failed: 1356: View 'test.mysqltest_tmp_v' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

The result from queries just before the failure was:

< snip >

#

# MDEV-30586: DELETE with WHERE containing nested subquery

#             with set function aggregated in outer subquery

#

create table t1 (a int);

insert into t1 values (3), (7), (1);

create table t2 (b int);

insert into t2 values (2), (1), (4), (7);

create table t3 (a int, b int);

insert into t3 values (2,10), (7,30), (2,30), (1,10), (7,40);

select * from t1

where t1.a in (select t3.a from t3 group by t3.a

having t3.a > any (select t2.b from t2

where t2.b*10 < sum(t3.b)));

--------------------------------------------------------------------------

The servers were restarted 0 times

Spent 0.000 of 3 seconds executing testcases

Failure: Failed 1/1 tests, 0.00% were successful.

Failing test(s): main.delete