diff options
| author | Sergey Petrunya <psergey@askmonty.org> | 2011-12-05 01:31:42 +0400 |
|---|---|---|
| committer | Sergey Petrunya <psergey@askmonty.org> | 2011-12-05 01:31:42 +0400 |
| commit | 255fd6c9294025ced406382980b0ad51960f0971 (patch) | |
| tree | e7d4f9097843a55ec9272790fa30d8c48cbf6c50 /mysql-test/r/subselect_cache.result | |
| parent | b5a05df61ea263aa3c3b9df78c56148adf029f04 (diff) | |
| download | mariadb-git-255fd6c9294025ced406382980b0ad51960f0971.tar.gz | |
Make subquery Materialization, as well as semi-join Materialization be shown
in EXPLAIN as select_type==MATERIALIZED.
Before, we had select_type==SUBQUERY and it was difficult to tell materialized
subqueries from uncorrelated scalar-context subqueries.
Diffstat (limited to 'mysql-test/r/subselect_cache.result')
| -rw-r--r-- | mysql-test/r/subselect_cache.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/subselect_cache.result b/mysql-test/r/subselect_cache.result index 8b04cc0c202..9bedf154cfd 100644 --- a/mysql-test/r/subselect_cache.result +++ b/mysql-test/r/subselect_cache.result @@ -1807,7 +1807,7 @@ set optimizer_switch='default,semijoin=off,materialization=on,subquery_cache=on' explain select * from t1 where a in (select pk from t2); id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY t1 ALL NULL NULL NULL NULL 15 Using where -2 SUBQUERY t2 ALL NULL NULL NULL NULL 10 +2 MATERIALIZED t2 ALL NULL NULL NULL NULL 10 flush status; select * from t1 where a in (select pk from t2); a b |