diff options
| author | Igor Babaev <igor@askmonty.org> | 2011-09-30 18:55:02 -0700 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2011-09-30 18:55:02 -0700 |
| commit | 715dc5f99ddf852a5ef45bcb68c6c86298f6a7c3 (patch) | |
| tree | 3557e3bfdfa8723372daf13fa6f46ffdd30483b6 /mysql-test/r/mrr_icp_extra.result | |
| parent | 42b928ca05fca3ae8858566622a3a483a70aa3fc (diff) | |
| download | mariadb-git-715dc5f99ddf852a5ef45bcb68c6c86298f6a7c3.tar.gz | |
Fixed a cost estimation bug introduced into in the function best_access_path
of the 5.3 code line after a merge with 5.2 on 2010-10-28
in order not to allow the cost to access a joined table to be equal
to 0 ever.
Expanded data sets for many test cases to get the same execution plans
as before.
Diffstat (limited to 'mysql-test/r/mrr_icp_extra.result')
| -rw-r--r-- | mysql-test/r/mrr_icp_extra.result | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/mysql-test/r/mrr_icp_extra.result b/mysql-test/r/mrr_icp_extra.result index 3014ec948f8..a4df3680dec 100644 --- a/mysql-test/r/mrr_icp_extra.result +++ b/mysql-test/r/mrr_icp_extra.result @@ -69,9 +69,10 @@ DROP TABLE t1,t2,t3; # create table t1(a int, b int, index(b)); insert into t1 values (2, 1), (1, 1), (4, NULL), (3, NULL), (6, 2), (5, 2); +insert into t1 values (2, 11), (1, 11), (4, 14), (3, 14), (6, 12), (5, 12); explain select * from t1 where b=1 or b is null order by a; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref_or_null b b 5 const 3 Using index condition; Using filesort +1 SIMPLE t1 ref_or_null b b 5 const 4 Using index condition; Using filesort select * from t1 where b=1 or b is null order by a; a b 1 1 @@ -80,7 +81,7 @@ a b 4 NULL explain select * from t1 where b=2 or b is null order by a; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref_or_null b b 5 const 4 Using index condition; Using filesort +1 SIMPLE t1 ref_or_null b b 5 const 3 Using index condition; Using filesort select * from t1 where b=2 or b is null order by a; a b 3 NULL |