Removed the parameter from st_select_lex_unit::exec_recursive.

Moved checking whether the limit set for the number of iterations
when executing a recursive query has been reached from
st_select_lex_unit::exec_recursive to TABLE_LIST::fill_recursive.
Changed the name of the system variable max_recursion_level for
max_recursive_iterations.
Adjusted test cases.

1 files changed, 3 insertions, 3 deletions

diff --git a/mysql-test/t/cte_recursive.test b/mysql-test/t/cte_recursive.test
index 60f058b15f7..98fe159e174 100644
--- a/mysql-test/t/cte_recursive.test
+++ b/mysql-test/t/cte_recursive.test
@@ -914,7 +914,7 @@ as
 )
 select * from ancestors;
 
-set statement max_recursion_level=2 for
+set statement max_recursive_iterations=1 for
 with recursive
 ancestor_ids (id, generation)
 as
@@ -1074,8 +1074,8 @@ create table t1(a int);
 insert into t1 values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
  
 explain format=json 
-with recursive T as (select a from t1 union select a+10 from T where a < 1000) 
-select  * from T;
+with recursive t as (select a from t1 union select a+10 from t where a < 1000) 
+select  * from t;
 
 drop table t1;