Test main.cte_nonrecursive on sporadic failures

main.cte_nonrecursive                    w3 [ fail ]

        Test ended at 2021-11-27 23:03:54

CURRENT_TEST: main.cte_nonrecursive

mysqltest: At line 1220: query 'drop database test' failed: ER_DB_DROP_RMDIR (1010): Error dropping database (can't rmdir './test', errno: 39 "Directory not empty")

The result from queries just before the failure was:

< snip >

# MDEV-18460: Server crashed in strmake / tdc_create_key /

# THD::create_tmp_table_def_key

#

connect con1,localhost,root,,;

CREATE TEMPORARY TABLE test.t (a INT);

WITH cte AS (SELECT 1) SELECT * FROM cte;

1

1

WITH t AS (SELECT 1) SELECT * FROM t;

1

1

WITH cte AS (SELECT 1) SELECT * FROM t;

ERROR 3D000: No database selected

DROP TABLE test.t;

connection default;

disconnect con1;

#

# MDEV-22781: create view with CTE without default database

#

drop database test;

More results from queries before failure can be found in /tmp/tmp.SRpydvPo6F/var/3/log/cte_nonrecursive.log

 - saving '/tmp/tmp.SRpydvPo6F/var/3/log/main.cte_nonrecursive/' to '/tmp/tmp.SRpydvPo6F/var/log/main.cte_nonrecursive/'