summaryrefslogtreecommitdiff
path: root/mysql-test/t/range_innodb.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/range_innodb.test
parentab1941266c59a19703a74b5593cf3f508a5752d7 (diff)
downloadmariadb-git-a7abddeffa6a760ce948c2dfb007cdf3f1a369d5.tar.gz
Create 'main' test directory and move 't' and 'r' there
Diffstat (limited to 'mysql-test/t/range_innodb.test')
-rw-r--r--mysql-test/t/range_innodb.test47
1 files changed, 0 insertions, 47 deletions
diff --git a/mysql-test/t/range_innodb.test b/mysql-test/t/range_innodb.test
deleted file mode 100644
index f76794814ef..00000000000
--- a/mysql-test/t/range_innodb.test
+++ /dev/null
@@ -1,47 +0,0 @@
---echo #
---echo # Range optimizer (and related) tests that need InnoDB.
---echo #
-
---source include/have_innodb.inc
-
---disable_warnings
-drop table if exists t0, t1, t2;
---enable_warnings
-
---echo #
---echo # MDEV-6735: Range checked for each record used with key
---echo #
-
-create table t0(a int);
-insert into t0 values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
-
-create table t1(a int);
-insert into t1 select A.a + B.a* 10 + C.a * 100 + D.a * 1000
-from t0 A, t0 B, t0 C, t0 D;
-
-create table t2 (
- a int,
- b int,
- filler1 char(100),
- filler2 char(100),
- filler3 char(100),
- filler4 char(100),
- key(a),
- key(b)
-) engine=innodb;
-
-insert into t2
-select
- a,a,
- repeat('0123456789', 10),
- repeat('0123456789', 10),
- repeat('0123456789', 10),
- repeat('0123456789', 10)
-from t1;
-
-analyze table t2;
---echo # The following must not use "Range checked for each record":
-explain select * from t0 left join t2 on t2.a <t0.a and t2.b between 50 and 250;
-
-drop table t0,t1,t2;
-