main.cte_update_delete doesnt' cleanup, refers to wrong MDEVs.

--echo #

--echo # MDEV-38272 Sig11 in LEX::resolve_references_to_cte at sql/sql_cte.cc

--echo #

create table t1(a int);

insert into t1 values (1), (5), (10), (15), (20), (25);

create view v1 as select * from t1 where a < 10;

--error ER_PARSE_ERROR

with cte as (select * from t1) delete from t1,cte where t1.a=cte.a;

with cte as (select * from t1) delete from t1 using t1,cte where t1.a=cte.a;

--echo #

--echo # MDEV-38272 Recursive CTE usage leaks memory when not used in a top level select

--echo #

commit 549628d9ccb822252b55210d922cef3d13eecd71

Author: Rex Johnston <rex.johnston@mariadb.com>

Date:   Tue Dec 9 02:40:52 2025 +1200

    MDEV-38272 Sig11 in LEX::resolve_references_to_cte at sql/sql_cte.cc

    Lex::save_list contents remain from a previous query that has invalid

    syntax and isn't reset when processing a new query.

    We initialize this structure along with it's peer in LEX::start.

    MDEV-38295 Recursive CTE usage leaks memory when not used in a top level select