summaryrefslogtreecommitdiff
path: root/mysql-test/main/range.test
diff options
context:
space:
mode:
authorSergei Petrunia <psergey@askmonty.org>2018-08-23 19:30:26 +0300
committerSergei Petrunia <psergey@askmonty.org>2018-08-23 19:30:26 +0300
commit6b9dd66f0770077b2573de5d16671e7463f8c5d5 (patch)
tree3d3fc14b42d01775d3195366e23462e77acbe4aa /mysql-test/main/range.test
parentc43d11b96e27f25d248f4740a2274f1bfb1d5845 (diff)
downloadmariadb-git-6b9dd66f0770077b2573de5d16671e7463f8c5d5.tar.gz
Move the testcase for BUG#21282 to a file that includes have_debug.inc
The testcase needs to set in_predicate_conversion_threshold which is only available in debug builds (this is subject to further discussion).
Diffstat (limited to 'mysql-test/main/range.test')
-rw-r--r--mysql-test/main/range.test28
1 files changed, 0 insertions, 28 deletions
diff --git a/mysql-test/main/range.test b/mysql-test/main/range.test
index 43b5b18435e..7006f15e320 100644
--- a/mysql-test/main/range.test
+++ b/mysql-test/main/range.test
@@ -863,34 +863,6 @@ select a, hex(filler) from t1 where a not between 'b' and 'b';
drop table t1,t2,t3;
#
-# BUG#21282
-#
-create table t1 (a int);
-insert into t1 values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
-create table t2 (a int, key(a));
-insert into t2 select 2*(A.a + 10*(B.a + 10*C.a)) from t1 A, t1 B, t1 C;
-
-set in_predicate_conversion_threshold= 2000;
-
-set @a="select * from t2 force index (a) where a NOT IN(0";
-select count(*) from (select @a:=concat(@a, ',', a) from t2 ) Z;
-set @a=concat(@a, ')');
-
-insert into t2 values (11),(13),(15);
-
-set @b= concat("explain ", @a);
-
-prepare stmt1 from @b;
-execute stmt1;
-
-prepare stmt1 from @a;
-execute stmt1;
-
-set in_predicate_conversion_threshold= default;
-
-drop table t1, t2;
-
-#
# Bug #18165: range access for BETWEEN with a constant for the first argument
#