From fbab0685a7b7f39db0217823ad90dd47034eae29 Mon Sep 17 00:00:00 2001 From: Sergei Golubchik Date: Tue, 28 Apr 2015 13:57:21 +0200 Subject: post-merge changes, fixes, and tests --- mysql-test/r/group_by.result | 10 ++++++++++ 1 file changed, 10 insertions(+) (limited to 'mysql-test/r/group_by.result') diff --git a/mysql-test/r/group_by.result b/mysql-test/r/group_by.result index 32f7d61319b..1518a2f8982 100644 --- a/mysql-test/r/group_by.result +++ b/mysql-test/r/group_by.result @@ -2339,6 +2339,16 @@ MIN(a) b 0 a DROP TABLE t1; +create table t1 (a int, b int); +insert into t1 values (1,11), (1,12), (2,22),(2,23), (4,44),(4,45); +create table t2 (c int, d int); +insert into t2 values (1,11), (1,12), (2,22),(2,23), (4,44),(4,45); +select distinct a,sum(b), (select d from t2 where c=a order by max(b) limit 1) from t1 group by a order by max(b); +a sum(b) (select d from t2 where c=a order by max(b) limit 1) +1 23 11 +2 45 22 +4 89 44 +drop table t1, t2; # # LP bug#993726 Wrong result from a query with ALL subquery predicate in WHERE # -- cgit v1.2.1