summaryrefslogtreecommitdiff
path: root/mysql-test/t/func_group.test
diff options
context:
space:
mode:
authorunknown <monty@mashka.mysql.fi>2003-02-07 15:06:23 +0200
committerunknown <monty@mashka.mysql.fi>2003-02-07 15:06:23 +0200
commitf06b0d9f3cfeaee8098db22eeecf41f6c072c479 (patch)
tree5cace589571553163ae26ddaaf6402dfe33ea6ac /mysql-test/t/func_group.test
parent2760ecc829a85507c8aefc1e6592b09874791946 (diff)
parent7f84171381a4459a37ca919e666736dd9d9c4ea8 (diff)
downloadmariadb-git-f06b0d9f3cfeaee8098db22eeecf41f6c072c479.tar.gz
Merge work:/my/mysql-4.0 into mashka.mysql.fi:/home/my/mysql-4.0
Diffstat (limited to 'mysql-test/t/func_group.test')
-rw-r--r--mysql-test/t/func_group.test2
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/t/func_group.test b/mysql-test/t/func_group.test
index 04a2ff68a92..1915c2172ad 100644
--- a/mysql-test/t/func_group.test
+++ b/mysql-test/t/func_group.test
@@ -21,7 +21,7 @@ select count(distinct a),count(distinct grp) from t1;
insert into t1 values (null,null,'');
select count(distinct a),count(distinct grp) from t1;
-select sum(a),count(a),avg(a),std(a),bit_or(a),bit_and(a),min(a),max(a),min(c),max(c) from t1;
+select sum(all a),count(all a),avg(all a),std(all a),bit_or(all a),bit_and(all a),min(all a),max(all a),min(all c),max(all c) from t1;
select grp, sum(a),count(a),avg(a),std(a),bit_or(a),bit_and(a),min(a),max(a),min(c),max(c) from t1 group by grp;
select grp, sum(a)+count(a)+avg(a)+std(a)+bit_or(a)+bit_and(a)+min(a)+max(a)+min(c)+max(c) as sum from t1 group by grp;