diff options
| author | Gleb Shchepa <gshchepa@mysql.com> | 2010-03-05 23:45:55 +0400 |
|---|---|---|
| committer | Gleb Shchepa <gshchepa@mysql.com> | 2010-03-05 23:45:55 +0400 |
| commit | 63a88e137365c4158e22c1c8aba7847b5a0ffe86 (patch) | |
| tree | 2ab378271247dc2fea2d46d81d4d2bb6d20d507a /mysql-test/r/subselect.result | |
| parent | fbad82deaaf075127c5b1d71a290d7900c152e43 (diff) | |
| download | mariadb-git-63a88e137365c4158e22c1c8aba7847b5a0ffe86.tar.gz | |
Bug #39653: find_shortest_key in sql_select.cc does not
consider clustered primary keys
Choosing a shortest index for the covering index scan,
the optimizer ignored the fact, that the clustered primary
key read involves whole table data.
The find_shortest_key function has been modified to
take into account that fact that a clustered PK has a
longest key of possible covering indices.
mysql-test/r/innodb_mysql.result:
Test case for bug #39653.
mysql-test/t/innodb_mysql.test:
Test case for bug #39653.
sql/sql_select.cc:
Bug #39653: find_shortest_key in sql_select.cc does not
consider clustered primary keys
The find_shortest_key function has been modified to
take into account that fact that a clustered PK has a
longest key of possible covering indices.
Diffstat (limited to 'mysql-test/r/subselect.result')
0 files changed, 0 insertions, 0 deletions