summaryrefslogtreecommitdiff
path: root/mysql-test/main/range_mrr_icp.result
diff options
context:
space:
mode:
authorIgor Babaev <igor@askmonty.org>2018-08-23 14:39:38 -0700
committerIgor Babaev <igor@askmonty.org>2018-08-23 14:39:38 -0700
commitb4cf8557e3821ff3220a5ec62ff937a1f96793e9 (patch)
tree5f353301c08121a340af4036ae304aa7fe1040df /mysql-test/main/range_mrr_icp.result
parent6b9dd66f0770077b2573de5d16671e7463f8c5d5 (diff)
downloadmariadb-git-b4cf8557e3821ff3220a5ec62ff937a1f96793e9.tar.gz
Corrected test results after the last change in range.test
Diffstat (limited to 'mysql-test/main/range_mrr_icp.result')
-rw-r--r--mysql-test/main/range_mrr_icp.result24
1 files changed, 0 insertions, 24 deletions
diff --git a/mysql-test/main/range_mrr_icp.result b/mysql-test/main/range_mrr_icp.result
index 483957ff39e..9ce6f8bf5f0 100644
--- a/mysql-test/main/range_mrr_icp.result
+++ b/mysql-test/main/range_mrr_icp.result
@@ -1050,30 +1050,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',