diff options
author | monty@mashka.mysql.fi <> | 2003-02-08 02:09:21 +0200 |
---|---|---|
committer | monty@mashka.mysql.fi <> | 2003-02-08 02:09:21 +0200 |
commit | c4e7cbe15835a5c3831115759b1e1fecd3f3de72 (patch) | |
tree | c7756d4055a66864255358a434503e7e0e1f6bff /mysql-test/t/func_group.test | |
parent | 7abe5e234e5458d28d3a7fc117ab536e7b355598 (diff) | |
download | mariadb-git-c4e7cbe15835a5c3831115759b1e1fecd3f3de72.tar.gz |
after merge fix
Diffstat (limited to 'mysql-test/t/func_group.test')
-rw-r--r-- | mysql-test/t/func_group.test | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/t/func_group.test b/mysql-test/t/func_group.test index fc3b089ece1..f0677ff98d5 100644 --- a/mysql-test/t/func_group.test +++ b/mysql-test/t/func_group.test @@ -24,7 +24,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(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 sum(all a),count(all a),avg(all a),std(all a),variance(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),variance(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)+variance(a)+bit_or(a)+bit_and(a)+min(a)+max(a)+min(c)+max(c) as sum from t1 group by grp; |