diff options
Diffstat (limited to 'mysql-test/main/group_by.result')
| -rw-r--r-- | mysql-test/main/group_by.result | 10 |
1 files changed, 4 insertions, 6 deletions
diff --git a/mysql-test/main/group_by.result b/mysql-test/main/group_by.result index ef5e500c314..79102ffaf61 100644 --- a/mysql-test/main/group_by.result +++ b/mysql-test/main/group_by.result @@ -1037,8 +1037,9 @@ FROM t1 AS t1_outer GROUP BY t1_outer.b; 21 21 SELECT (SELECT SUM(t1_inner.a) FROM t1 AS t1_inner GROUP BY t1_inner.b LIMIT 1) +AS m FROM t1 AS t1_outer; -(SELECT SUM(t1_inner.a) FROM t1 AS t1_inner GROUP BY t1_inner.b LIMIT 1) +m 3 3 3 @@ -1278,12 +1279,9 @@ a select avg ( (select (select sum(outr.a + innr.a) from t1 as innr limit 1) as tt -from t1 as outr order by outr.a limit 1)) +from t1 as outr order by outr.a limit 1)) as m from t1 as most_outer; -avg ( -(select -(select sum(outr.a + innr.a) from t1 as innr limit 1) as tt -from t1 as outr order by outr.a limit 1)) +m 29.0000 select avg ( (select ( |