diff options
| author | Mattias Jonsson <mattias.jonsson@oracle.com> | 2010-09-14 10:56:11 +0200 |
|---|---|---|
| committer | Mattias Jonsson <mattias.jonsson@oracle.com> | 2010-09-14 10:56:11 +0200 |
| commit | 0b3a1807a1452e3936f9bc84425650bf924799d7 (patch) | |
| tree | 5997a7fad7e77733494160516bb0c953e9c3ee96 | |
| parent | 92655149a60bf990e785f39e7c4f3142049bb495 (diff) | |
| parent | 9d1ed095f5330bf894eac7ed977863e820946d30 (diff) | |
| download | mariadb-git-0b3a1807a1452e3936f9bc84425650bf924799d7.tar.gz | |
post push patch, fixing test result for bug#53806/46754.
| -rw-r--r-- | mysql-test/r/partition_column.result | 4 | ||||
| -rw-r--r-- | mysql-test/r/partition_column_prune.result | 4 |
2 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/r/partition_column.result b/mysql-test/r/partition_column.result index 7b45ffcb0de..a494656a6a6 100644 --- a/mysql-test/r/partition_column.result +++ b/mysql-test/r/partition_column.result @@ -611,7 +611,7 @@ partition p1 values less than (3,3), partition p2 values less than (9,5)); explain partitions select * from t1 where b < 2; id select_type table partitions type possible_keys key key_len ref rows Extra -1 SIMPLE t1 p0,p1 ALL NULL NULL NULL NULL 7 Using where +1 SIMPLE t1 p0,p1 ALL NULL NULL NULL NULL 5 Using where select * from t1 where b < 2; a b 0 1 @@ -647,7 +647,7 @@ alter table t1 reorganize partition p2 into partition p22 values less than (9,5)); explain partitions select * from t1 where b < 4; id select_type table partitions type possible_keys key key_len ref rows Extra -1 SIMPLE t1 p0,p11,p12,p21 ALL NULL NULL NULL NULL 7 Using where +1 SIMPLE t1 p0,p11,p12,p21 ALL NULL NULL NULL NULL 6 Using where select * from t1 where b < 4; a b 0 1 diff --git a/mysql-test/r/partition_column_prune.result b/mysql-test/r/partition_column_prune.result index 844429d24a6..95b45f4dea5 100644 --- a/mysql-test/r/partition_column_prune.result +++ b/mysql-test/r/partition_column_prune.result @@ -59,8 +59,8 @@ id select_type table partitions type possible_keys key key_len ref rows Extra 1 SIMPLE t1 p01,p02,p03,p11 ALL NULL NULL NULL NULL 8 Using where explain partitions select * from t1 where a=4; id select_type table partitions type possible_keys key key_len ref rows Extra -1 SIMPLE t1 p11,p12,p13,p21 ALL NULL NULL NULL NULL 14 Using where +1 SIMPLE t1 p11,p12,p13,p21 ALL NULL NULL NULL NULL 8 Using where explain partitions select * from t1 where a=2 and b < 22; id select_type table partitions type possible_keys key key_len ref rows Extra -1 SIMPLE t1 p01,p02,p03 ALL NULL NULL NULL NULL 14 Using where +1 SIMPLE t1 p01,p02,p03 ALL NULL NULL NULL NULL 6 Using where drop table t1; |