core_test: add cases that local temporary table works well for cte (#27174)
core_test: add cases that local temporary table works well for cte (#27174)

 
pingcap/tidb,pingcap/tidb,kyle-wang/tidb,kyle-wang/tidb,c4pt0r/tidb,ngaut/tidb,kyle-wang/tidb,c4pt0r/tidb,pingcap/tidb,pingcap/tidb,c4pt0r/tidb,c4pt0r/tidb,coocood/tidb,coocood/tidb,pingcap/tidb,ngaut/tidb,ngaut/tidb,ngaut/tidb,kyle-wang/tidb,ngaut/tidb,ngaut/tidb,pingcap/tidb,c4pt0r/tidb,kyle-wang/tidb,kyle-wang/tidb,c4pt0r/tidb