diff options
| author | unknown <Sinisa@sinisa.nasamreza.org> | 2002-11-09 15:40:46 +0200 |
|---|---|---|
| committer | unknown <Sinisa@sinisa.nasamreza.org> | 2002-11-09 15:40:46 +0200 |
| commit | f980950bb3b19df3de3030c531ecff99ecb323e1 (patch) | |
| tree | 3c10dade9a6185810108c75e43d33d2ac7fd6a99 /mysql-test | |
| parent | 826aa607ff323a126b62406e75bea154a20c30a8 (diff) | |
| download | mariadb-git-f980950bb3b19df3de3030c531ecff99ecb323e1.tar.gz | |
Some code optimisations related to EXPLAIN of derived tables and the
resulting code cleanup in our main loop.
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/subselect.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/subselect.result b/mysql-test/r/subselect.result index b1bf134fdde..5674bf3c473 100644 --- a/mysql-test/r/subselect.result +++ b/mysql-test/r/subselect.result @@ -71,8 +71,8 @@ select (select t3.a from t3 where a<8 order by 1 desc limit 1), a from explain select (select t3.a from t3 where a<8 order by 1 desc limit 1), a from (select * from t2 where a>1) as tt; id select_type table type possible_keys key key_len ref rows Extra -3 DERIVED t2 ALL NULL NULL NULL NULL 2 where used 1 PRIMARY <derived3> system NULL NULL NULL NULL 1 +3 DERIVED t2 ALL NULL NULL NULL NULL 2 where used 2 SUBSELECT t3 ALL NULL NULL NULL NULL 3 where used; Using filesort select * from t1 where t1.a=(select t2.a from t2 where t2.b=(select max(a) from t3) order by 1 desc limit 1); a |