MDEV-15571 Wrong results with big_tables=1 and CTE

The cause of this bug was the same as for the bug mdev-15575.
Fixed by the patch for the latter.

1 files changed, 17 insertions, 0 deletions

diff --git a/mysql-test/t/cte_recursive.test b/mysql-test/t/cte_recursive.test
index 373d6ca97cd..008c8ea9296 100644
--- a/mysql-test/t/cte_recursive.test
+++ b/mysql-test/t/cte_recursive.test
@@ -2109,3 +2109,20 @@ with recursive qn as
 select * from qn;
 
 set big_tables=default;
+
+--echo #
+--echo # MDEV-1571: Setting user variable in recursive CTE
+--echo #
+
+set big_tables=1;
+
+--error ER_DATA_OUT_OF_RANGE
+with recursive qn as
+(
+  select 1 as a from dual
+  union all
+  select a*2000 from qn where a<10000000000000000000
+)
+select * from qn;
+
+set big_tables=default;