aboutsummaryrefslogtreecommitdiff
path: root/test/distinctagg.test
diff options
context:
space:
mode:
Diffstat (limited to 'test/distinctagg.test')
-rw-r--r--test/distinctagg.test9
1 files changed, 7 insertions, 2 deletions
diff --git a/test/distinctagg.test b/test/distinctagg.test
index b2191ea43..9b5dc2167 100644
--- a/test/distinctagg.test
+++ b/test/distinctagg.test
@@ -11,7 +11,7 @@
# This file implements regression tests for SQLite library. The
# focus of this script is the DISTINCT modifier on aggregate functions.
#
-# $Id: distinctagg.test,v 1.2 2005/09/12 23:03:17 drh Exp $
+# $Id: distinctagg.test,v 1.3 2009/02/09 13:19:28 drh Exp $
set testdir [file dirname $argv0]
@@ -52,6 +52,11 @@ do_test distinctagg-2.1 {
catchsql {
SELECT count(distinct) FROM t1;
}
-} {1 {DISTINCT in aggregate must be followed by an expression}}
+} {1 {DISTINCT aggregates must have exactly one argument}}
+do_test distinctagg-2.2 {
+ catchsql {
+ SELECT group_concat(distinct a,b) FROM t1;
+ }
+} {1 {DISTINCT aggregates must have exactly one argument}}
finish_test