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/table_elim.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/table_elim.result')
| -rw-r--r-- | mysql-test/r/table_elim.result | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/mysql-test/r/table_elim.result b/mysql-test/r/table_elim.result index 3ad02914ca8..b4d3a2f6f2f 100644 --- a/mysql-test/r/table_elim.result +++ b/mysql-test/r/table_elim.result @@ -272,7 +272,8 @@ drop table t1, t2; create table t1 (a char(10) primary key); insert into t1 values ('foo'),('bar'); create table t2 (a char(10), unique key(a(2))); -insert into t2 values ('foo'),('bar'); +insert into t2 values +('foo'),('bar'),('boo'),('car'),('coo'),('par'),('doo'),('tar'); explain select t1.* from t1 left join t2 on t2.a=t1.a; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 index NULL PRIMARY 10 NULL 2 Using index |