diff options
author | Igor Babaev <igor@askmonty.org> | 2019-02-08 01:07:27 -0800 |
---|---|---|
committer | Igor Babaev <igor@askmonty.org> | 2019-02-08 01:07:27 -0800 |
commit | 651347b6c1133e8b666703b75f478a2fb565c73d (patch) | |
tree | e4b654861d2fd96a763a11813c9cdc11269235ae /mysql-test/main/partition_pruning.result | |
parent | 6cb2ab53284a64e0f2aba48f458cd4a6028a4639 (diff) | |
download | mariadb-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.result | 8 |
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); |