From b3b35a26f843a75330c6536bc9502db679d50abd Mon Sep 17 00:00:00 2001 From: Adam Chlipala Date: Thu, 28 Aug 2008 12:58:11 -0400 Subject: Tested aggregate functions with GROUP BY --- tests/agg.lac | 3 +++ 1 file changed, 3 insertions(+) (limited to 'tests') diff --git a/tests/agg.lac b/tests/agg.lac index f9b744e9..8aa72e6c 100644 --- a/tests/agg.lac +++ b/tests/agg.lac @@ -5,3 +5,6 @@ val q1 = (SELECT COUNT( * ) AS X FROM t1) val q2 = (SELECT AVG(t1.A) AS X FROM t1) val q3 = (SELECT SUM(t1.C) AS X FROM t1) val q4 = (SELECT MIN(t1.B) AS X, MAX(t1.A) AS Y FROM t1) + +(*val q5 = (SELECT t1.A FROM t1 GROUP BY t1.B)*) +val q5 = (SELECT SUM(t1.A) AS X FROM t1 GROUP BY t1.B) -- cgit v1.2.3