summaryrefslogtreecommitdiff
path: root/mysql-test/t/subselect_notembedded.test
diff options
context:
space:
mode:
authorMichael Widenius <monty@mariadb.org>2018-03-09 14:05:35 +0200
committerMonty <monty@mariadb.org>2018-03-29 13:59:44 +0300
commita7abddeffa6a760ce948c2dfb007cdf3f1a369d5 (patch)
tree70eb743fa965a17380bbc0ac88ae79ca1075b896 /mysql-test/t/subselect_notembedded.test
parentab1941266c59a19703a74b5593cf3f508a5752d7 (diff)
downloadmariadb-git-a7abddeffa6a760ce948c2dfb007cdf3f1a369d5.tar.gz
Create 'main' test directory and move 't' and 'r' there
Diffstat (limited to 'mysql-test/t/subselect_notembedded.test')
-rw-r--r--mysql-test/t/subselect_notembedded.test62
1 files changed, 0 insertions, 62 deletions
diff --git a/mysql-test/t/subselect_notembedded.test b/mysql-test/t/subselect_notembedded.test
deleted file mode 100644
index dcda71c767f..00000000000
--- a/mysql-test/t/subselect_notembedded.test
+++ /dev/null
@@ -1,62 +0,0 @@
--- source include/not_embedded.inc
-
-#
-# BUG#10308: purge log with subselect
-# Bug#28553: mysqld crash in "purge master log before(select time from information_schema)"
-#
---error 1064
-purge master logs before (select adddate(current_timestamp(), interval -4 day));
-purge master logs before adddate(current_timestamp(), interval -4 day);
-
---disable_warnings
-drop table if exists t1;
---enable_warnings
-#
-# Bug31048: Many nested subqueries may cause server crash.
-#
-create table t1(a int,b int,key(a),key(b));
-insert into t1(a,b) values (1,2),(2,1),(2,3),(3,4),(5,4),(5,5),
- (6,7),(7,4),(5,3);
-
-let $nesting= 26;
-let $should_work_nesting= 5;
-let $start= select sum(a),a from t1 where a> ( select sum(a) from t1 ;
-let $end= )group by a ;
-let $start_app= where a> ( select sum(a) from t1 ;
-let $end_pre= )group by b limit 1 ;
-
---disable_result_log
---disable_query_log
-# At least 4 level nesting should work without errors
-while ($should_work_nesting)
-{
---echo $should_work_nesting
- eval select $should_work_nesting as 'STEP-1';
- eval $start $end;
- eval explain $start $end;
- let $start= $start
- $start_app;
- let $end= $end_pre
- $end;
- dec $should_work_nesting;
-}
-# Other may fail with the 'stack overrun error'
-while ($nesting)
-{
---echo $nesting
- eval select $nesting as 'STEP-2';
---error 0,1436
- eval $start $end;
---error 0,1436
- eval explain $start $end;
- let $start= $start
- $start_app;
- let $end= $end_pre
- $end;
- dec $nesting;
-}
---enable_result_log
---enable_query_log
-drop table t1;
-
---echo End of 5.1 tests