diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2018-04-25 07:58:46 +0300 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2018-04-25 07:59:25 +0300 |
| commit | 9477a2a9ba17c0db362e2bb39d5048e369096f39 (patch) | |
| tree | 822c938585709a1bdf2262ece3167f6e0a911e94 /mysql-test/main/cte_recursive.test | |
| parent | e3fb8e95692fcb554d83a76c5dd6e0b9a6c62728 (diff) | |
| parent | f033fbd9f2366619c52186a1a902066495539141 (diff) | |
| download | mariadb-git-9477a2a9ba17c0db362e2bb39d5048e369096f39.tar.gz | |
Merge 10.2 into 10.3
Diffstat (limited to 'mysql-test/main/cte_recursive.test')
| -rw-r--r-- | mysql-test/main/cte_recursive.test | 7 |
1 files changed, 6 insertions, 1 deletions
diff --git a/mysql-test/main/cte_recursive.test b/mysql-test/main/cte_recursive.test index 1d4e328081b..0647e6c15c3 100644 --- a/mysql-test/main/cte_recursive.test +++ b/mysql-test/main/cte_recursive.test @@ -2114,12 +2114,15 @@ set big_tables=default; --echo # MDEV-15571: using recursive cte with big_tables enabled --echo # +create table t1 (a bigint); +insert into t1 values(1); + set big_tables=1; --error ER_DATA_OUT_OF_RANGE with recursive qn as ( - select 1 as a from dual + select a from t1 union all select a*2000 from qn where a<10000000000000000000 ) @@ -2127,6 +2130,8 @@ select * from qn; set big_tables=default; +drop table t1; + --echo # --echo # MDEV-15556: using recursive cte with big_tables enabled --echo # when recursive tables are accessed by key |