diff options
Diffstat (limited to 'mysql-test/main/func_group.test')
-rw-r--r-- | mysql-test/main/func_group.test | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/main/func_group.test b/mysql-test/main/func_group.test index fa1fd0f99dd..2aa816efe8b 100644 --- a/mysql-test/main/func_group.test +++ b/mysql-test/main/func_group.test @@ -1797,5 +1797,16 @@ DROP TABLE t1; SET STATEMENT sql_mode=ONLY_FULL_GROUP_BY FOR EXECUTE IMMEDIATE 'ALTER TABLE mysql.time_zone_transition ORDER BY Time_zone_id, Transition_time'; --echo # +--echo # MDEV-19071 Wrong results when using STDDEV_SAMP() and view +--echo # +create table t1(i int); +insert into t1 values (1),(2),(3),(4),(5); +create view v1 as select stddev_samp(i),stddev_pop(i),stddev(i),std(i) from t1; +show create view v1; +select * from v1; +drop view v1; +drop table t1; + +--echo # --echo # End of 10.3 tests --echo # |