diff options
| author | unknown <vva@eagle.mysql.r18.ru> | 2002-12-14 03:36:59 +0400 |
|---|---|---|
| committer | unknown <vva@eagle.mysql.r18.ru> | 2002-12-14 03:36:59 +0400 |
| commit | e10f255dd6d04ccace27580e196e20b1a18b98cd (patch) | |
| tree | aec2e74172b465c0f467414b55fa86e25ab8d550 /mysql-test/t/having.test | |
| parent | 3b33f0c2c14c9e210b81d8ee784c75f83ce99636 (diff) | |
| download | mariadb-git-e10f255dd6d04ccace27580e196e20b1a18b98cd.tar.gz | |
add VARIANCE function
mysql-test/r/func_group.result:
add 'VARIANCE' tests
mysql-test/r/having.result:
add 'VARIANCE' tests
mysql-test/r/select.result:
add 'VARIANCE' tests
mysql-test/t/func_group.test:
add 'VARIANCE' tests
mysql-test/t/having.test:
add 'VARIANCE' tests
mysql-test/t/select.test:
add 'VARIANCE' tests
sql/item.cc:
add 'VARIANCE' sum function
sql/item.h:
add 'VARIANCE' sum function
sql/item_sum.cc:
add 'VARIANCE' sum function
sql/item_sum.h:
add 'VARIANCE' sum function
BitKeeper/etc/logging_ok:
Logging to logging@openlogging.org accepted
Diffstat (limited to 'mysql-test/t/having.test')
| -rw-r--r-- | mysql-test/t/having.test | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/mysql-test/t/having.test b/mysql-test/t/having.test index 8dd7606d82b..7f0a1225bda 100644 --- a/mysql-test/t/having.test +++ b/mysql-test/t/having.test @@ -59,4 +59,5 @@ select Fld1, max(Fld2) as q from t1 group by Fld1 having q is not null; select Fld1, max(Fld2) from t1 group by Fld1 having max(Fld2) is not null; select Fld1, max(Fld2) from t1 group by Fld1 having avg(Fld2) is not null; select Fld1, max(Fld2) from t1 group by Fld1 having std(Fld2) is not null; +select Fld1, max(Fld2) from t1 group by Fld1 having variance(Fld2) is not null; drop table t1; |