diff options
| author | Igor Babaev <igor@askmonty.org> | 2012-05-16 20:39:03 -0700 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2012-05-16 20:39:03 -0700 |
| commit | 4dc963a9f3364395f0ade47f1cf212942fd23448 (patch) | |
| tree | 9f1d8de1d13bc897a851bbdf1d73698921c9aacd /mysql-test/suite/innodb/r | |
| parent | c17bace4f0d05a6852c465513005812e5dc35b6f (diff) | |
| download | mariadb-git-4dc963a9f3364395f0ade47f1cf212942fd23448.tar.gz | |
Fixed LP bug #999251: Q13 from DBT3 uses table scan instead of covering index scan.
The optimizer chose a less efficient execution plan due to the following
defects of the code:
1. the generic handler function handler::keyread_time did not take into account
that in clustered primary keys record data is included into each index entry
2. the function make_join_readinfo erroneously decided that index only scan
could not be used if join cache was empoyed.
Added no additional test case.
Adjusted some of the test results.
Diffstat (limited to 'mysql-test/suite/innodb/r')
| -rw-r--r-- | mysql-test/suite/innodb/r/innodb_mysql.result | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/suite/innodb/r/innodb_mysql.result b/mysql-test/suite/innodb/r/innodb_mysql.result index a1782ea5f6e..2b3d24551c7 100644 --- a/mysql-test/suite/innodb/r/innodb_mysql.result +++ b/mysql-test/suite/innodb/r/innodb_mysql.result @@ -2365,8 +2365,8 @@ select_type SIMPLE table t1 type index possible_keys NULL -key PRIMARY -key_len 4 +key b +key_len 10 ref NULL rows 10 Extra Using index @@ -2652,7 +2652,7 @@ select_type SIMPLE table t1 type index possible_keys NULL -key PRIMARY +key b key_len 8 ref NULL rows 3 |