diff options
| author | Evgeny Potemkin <epotemkin@mysql.com> | 2010-02-26 14:19:44 +0300 |
|---|---|---|
| committer | Evgeny Potemkin <epotemkin@mysql.com> | 2010-02-26 14:19:44 +0300 |
| commit | a0723c066506974732f3498e8041f60ecd43e420 (patch) | |
| tree | a17ba0412ba1a37a5ad9c71c5fc0f9fc7b4170fc /mysql-test/r | |
| parent | 79d8de67a911be0f18adfd4c19c65909879b76eb (diff) | |
| parent | cc01fc3f5f1860670113f10a1ac968a8067ab071 (diff) | |
| download | mariadb-git-a0723c066506974732f3498e8041f60ecd43e420.tar.gz | |
Auto-merged fox for the bug#50843.
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/innodb_mysql.result | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/r/innodb_mysql.result b/mysql-test/r/innodb_mysql.result index b54fb90b412..c4279018cb8 100644 --- a/mysql-test/r/innodb_mysql.result +++ b/mysql-test/r/innodb_mysql.result @@ -2281,4 +2281,18 @@ CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=innodb ; SELECT 1 FROM t1 JOIN t1 a USING(a) GROUP BY t1.a,t1.a; 1 DROP TABLE t1; +# +# Bug#50843: Filesort used instead of clustered index led to +# performance degradation. +# +create table t1(f1 int not null primary key, f2 int) engine=innodb; +create table t2(f1 int not null, key (f1)) engine=innodb; +insert into t1 values (1,1),(2,2),(3,3); +insert into t2 values (1),(2),(3); +explain select t1.* from t1 left join t2 using(f1) group by t1.f1; +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE t1 index NULL PRIMARY 4 NULL 3 +1 SIMPLE t2 ref f1 f1 4 test.t1.f1 1 Using index +drop table t1,t2; +# End of 5.1 tests |