diff options
| author | Lena Startseva <lena.startseva@mariadb.com> | 2022-09-27 13:17:59 +0700 |
|---|---|---|
| committer | Lena Startseva <lena.startseva@mariadb.com> | 2022-09-27 13:17:59 +0700 |
| commit | f8f25b472e99569c88820787e293801208768b41 (patch) | |
| tree | 5706936ec41f10a3ed3b4ed807b8e7b994ad4bdd /mysql-test/main/func_group.test | |
| parent | 789f55c947a8aa224e5b0a71d5c0bea375320091 (diff) | |
| parent | 2abf499c76a5b872e8dbf84aaa20e1990ed6407e (diff) | |
| download | mariadb-git-f8f25b472e99569c88820787e293801208768b41.tar.gz | |
Merge branch 'bb-10.5-all-builders' into bb-10.6-all-builders
Diffstat (limited to 'mysql-test/main/func_group.test')
| -rw-r--r-- | mysql-test/main/func_group.test | 10 |
1 files changed, 9 insertions, 1 deletions
diff --git a/mysql-test/main/func_group.test b/mysql-test/main/func_group.test index 381bdebdc16..7309ca4cdfe 100644 --- a/mysql-test/main/func_group.test +++ b/mysql-test/main/func_group.test @@ -587,6 +587,8 @@ DROP TABLE t1; # # Bug #16792 query with subselect, join, and group not returning proper values # +#enable after fix MDEV-28573 +--disable_view_protocol CREATE TABLE t1 (a INT, b INT); INSERT INTO t1 VALUES (1,1),(1,2),(2,3); @@ -597,6 +599,7 @@ SELECT AVG(2), BIT_AND(2), BIT_OR(2), BIT_XOR(2), COUNT(*), COUNT(12), COUNT(DISTINCT 12), MIN(2),MAX(2),STD(2), VARIANCE(2),SUM(2), GROUP_CONCAT(2),GROUP_CONCAT(DISTINCT 2); DROP TABLE t1; +--enable_view_protocol # End of 4.1 tests @@ -628,11 +631,13 @@ drop table t1, t2, t3; # # BUG#3190, WL#1639: Standard Deviation STDDEV - 2 different calculations # - +#enable after fix MDEV-28573 +--disable_view_protocol CREATE TABLE t1 (id int(11),value1 float(10,2)); INSERT INTO t1 VALUES (1,0.00),(1,1.00), (1,2.00), (2,10.00), (2,11.00), (2,12.00), (2,13.00); select id, stddev_pop(value1), var_pop(value1), stddev_samp(value1), var_samp(value1) from t1 group by id; DROP TABLE t1; +--enable_view_protocol # # BUG#8464 decimal AVG returns incorrect result @@ -969,6 +974,8 @@ INSERT INTO D VALUES (83,45,4,repeat(' X', 42)), (105,53,12,NULL); +#enable after fix MDEV-27871 +--disable_view_protocol SELECT (SELECT COUNT( int_nokey ) FROM derived1 AS X @@ -982,6 +989,7 @@ GROUP BY int_nokey LIMIT 1; DROP TABLE derived1; DROP TABLE D; +--enable_view_protocol # # Bug #39656: Behaviour different for agg functions with & without where - |