CTE statement left spilled files unremoved

[yibin87]

Bug Report

Please answer these questions before submitting your issue. Thanks!
CTE statment executed successfully, while left spilled files unremoved.

The CTEFullScan_68 occupied 2.6GB disk size, and not released finally.

4. What is your TiDB version? (Required)

v6.1.x

[guo-shaoge]

Reproduce steps:

1. start tidb-server
2. run following sqls:

drop table t1, t2;
create table t1(c1 int, c2 int);
create table t2(c1 int);
set @@cte_max_recursion_depth = 1000000;
set global tidb_mem_oom_action = 'log';
set @@tidb_mem_quota_query = 100;
select @@tidb_mem_oom_action; # make sure tidb_mem_oom_action is log
insert into t2 values(1);
insert into t1 (c1, c2) with recursive cte1 as (select c1 from t2 union select cte1.c1 + 1 from cte1 where cte1.c1 < 1000000) select cte1.c1, cte1.c1+1 from cte1;

3. check /tmp/1000_tidb/xxx/xxx, you can see remaining chunk list file even when sql finish

[guo-shaoge]

select stmt is ok, Ohter DML has this problem.