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/group_by.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/group_by.result')
| -rw-r--r-- | mysql-test/r/group_by.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/group_by.result b/mysql-test/r/group_by.result index 1f93171c09d..5804e8983a3 100644 --- a/mysql-test/r/group_by.result +++ b/mysql-test/r/group_by.result @@ -1544,7 +1544,7 @@ EXPLAIN SELECT 1 FROM t1 WHERE a IN id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY t1 index PRIMARY,i2 PRIMARY 4 NULL 144 Using index 1 PRIMARY <subquery2> eq_ref distinct_key distinct_key 4 func 1 -2 SUBQUERY t1 ALL NULL NULL NULL NULL 144 +2 MATERIALIZED t1 ALL NULL NULL NULL NULL 144 CREATE TABLE t2 (a INT, b INT, KEY(a)); INSERT INTO t2 VALUES (1, 1), (2, 2), (3,3), (4,4); EXPLAIN SELECT a, SUM(b) FROM t2 GROUP BY a LIMIT 2; |