summaryrefslogtreecommitdiff
path: root/mysql-test/main/partition_pruning.result
diff options
context:
space:
mode:
authorIgor Babaev <igor@askmonty.org>2019-02-08 01:07:27 -0800
committerIgor Babaev <igor@askmonty.org>2019-02-08 01:07:27 -0800
commit651347b6c1133e8b666703b75f478a2fb565c73d (patch)
treee4b654861d2fd96a763a11813c9cdc11269235ae /mysql-test/main/partition_pruning.result
parent6cb2ab53284a64e0f2aba48f458cd4a6028a4639 (diff)
downloadmariadb-git-651347b6c1133e8b666703b75f478a2fb565c73d.tar.gz
MDEV-16188 Post merge fixes fot TokuDB
Diffstat (limited to 'mysql-test/main/partition_pruning.result')
-rw-r--r--mysql-test/main/partition_pruning.result8
1 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/main/partition_pruning.result b/mysql-test/main/partition_pruning.result
index 6402f230354..15767556f37 100644
--- a/mysql-test/main/partition_pruning.result
+++ b/mysql-test/main/partition_pruning.result
@@ -2676,13 +2676,13 @@ explain partitions
select * from t1 X, t1 Y
where X.b = Y.b and (X.a=1 or X.a=2) and (Y.a=2 or Y.a=3);
id select_type table partitions type possible_keys key key_len ref rows Extra
-1 SIMPLE X p1,p2 range a,b a 4 NULL 4 Using where
-1 SIMPLE Y p2,p3 ref|filter a,b b|a 4|4 test.X.b 2 (50%) Using where; Using rowid filter
+1 SIMPLE X p1,p2 ALL a,b NULL NULL NULL 8 Using where
+1 SIMPLE Y p2,p3 ALL a,b NULL NULL NULL 8 Using where; Using join buffer (flat, BNL join)
explain partitions
select * from t1 X, t1 Y where X.a = Y.a and (X.a=1 or X.a=2);
id select_type table partitions type possible_keys key key_len ref rows Extra
-1 SIMPLE X p1,p2 range a a 4 NULL 4 Using where
-1 SIMPLE Y p1,p2 ref a a 4 test.X.a 2
+1 SIMPLE X p1,p2 ALL a NULL NULL NULL 8 Using where
+1 SIMPLE Y p1,p2 ALL a NULL NULL NULL 8 Using where; Using join buffer (flat, BNL join)
drop table t1;
create table t1 (a int) partition by hash(a) partitions 20;
insert into t1 values (1),(2),(3);