summaryrefslogtreecommitdiff
path: root/mysql-test/main/range.result
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.result
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.result')
-rw-r--r--mysql-test/main/range.result24
1 files changed, 0 insertions, 24 deletions
diff --git a/mysql-test/main/range.result b/mysql-test/main/range.result
index cbf9d5bb7d9..052ea09d5ac 100644
--- a/mysql-test/main/range.result
+++ b/mysql-test/main/range.result
@@ -1048,30 +1048,6 @@ select a, hex(filler) from t1 where a not between 'b' and 'b';
a hex(filler)
a 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
drop table t1,t2,t3;
-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;
-count(*)
-1000
-set @a=concat(@a, ')');
-insert into t2 values (11),(13),(15);
-set @b= concat("explain ", @a);
-prepare stmt1 from @b;
-execute stmt1;
-id select_type table type possible_keys key key_len ref rows Extra
-1 SIMPLE t2 index a a 5 NULL 1003 Using where; Using index
-prepare stmt1 from @a;
-execute stmt1;
-a
-11
-13
-15
-set in_predicate_conversion_threshold= default;
-drop table t1, t2;
CREATE TABLE t1 (
id int NOT NULL DEFAULT '0',
b int NOT NULL DEFAULT '0',