summaryrefslogtreecommitdiff
path: root/mysql-test/suite/pbxt
diff options
context:
space:
mode:
authorSergey Petrunya <psergey@askmonty.org>2011-12-05 10:24:14 +0400
committerSergey Petrunya <psergey@askmonty.org>2011-12-05 10:24:14 +0400
commita85454def888a71669860240c7a622c674accd37 (patch)
treed70b5eff8d9b70776442771f267ce9065aa0d708 /mysql-test/suite/pbxt
parent255fd6c9294025ced406382980b0ad51960f0971 (diff)
downloadmariadb-git-a85454def888a71669860240c7a622c674accd37.tar.gz
Update test result missed in the previous cset
Diffstat (limited to 'mysql-test/suite/pbxt')
-rw-r--r--mysql-test/suite/pbxt/r/group_min_max.result2
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/suite/pbxt/r/group_min_max.result b/mysql-test/suite/pbxt/r/group_min_max.result
index ecc19e1531a..b73b393f9da 100644
--- a/mysql-test/suite/pbxt/r/group_min_max.result
+++ b/mysql-test/suite/pbxt/r/group_min_max.result
@@ -2258,7 +2258,7 @@ a IN (SELECT max(b) FROM t1 GROUP BY a HAVING a < 2);
id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY <subquery2> ALL distinct_key NULL NULL NULL 15 Using where
1 PRIMARY t1_outer ref a a 5 <subquery2>.max(b) 1 Using index
-2 SUBQUERY t1 index NULL a 10 NULL 15 Using index
+2 MATERIALIZED t1 index NULL a 10 NULL 15 Using index
EXPLAIN SELECT 1 FROM t1 AS t1_outer GROUP BY a HAVING
a > (SELECT max(b) FROM t1 GROUP BY a HAVING a < 2);
id select_type table type possible_keys key key_len ref rows Extra