diff options
author | Sergei Golubchik <serg@mariadb.org> | 2022-12-18 16:30:26 +0100 |
---|---|---|
committer | Sergei Golubchik <serg@mariadb.org> | 2023-01-02 00:04:03 +0100 |
commit | 21223c0461455b4175bae91aee7e3525a51c6d70 (patch) | |
tree | fa0d2d2b6ddf4befe1b3081528bfe92d47b167ef /mysql-test/main/func_group.result | |
parent | 908c48a34dd94350c87c89a32937bf32399c3ab4 (diff) | |
download | mariadb-git-21223c0461455b4175bae91aee7e3525a51c6d70.tar.gz |
MDEV-29988 group by fix
Diffstat (limited to 'mysql-test/main/func_group.result')
-rw-r--r-- | mysql-test/main/func_group.result | 11 |
1 files changed, 10 insertions, 1 deletions
diff --git a/mysql-test/main/func_group.result b/mysql-test/main/func_group.result index 0f80d14b603..6617d21a197 100644 --- a/mysql-test/main/func_group.result +++ b/mysql-test/main/func_group.result @@ -1,4 +1,3 @@ -drop table if exists t1,t2,t3,t4,t5,t6; set @sav_dpi= @@div_precision_increment; set div_precision_increment= 5; show variables like 'div_precision_increment'; @@ -2566,5 +2565,15 @@ stddev_samp(i) stddev_pop(i) stddev(i) std(i) drop view v1; drop table t1; # +# MDEV-29988: Major performance regression with 10.6.11 +# +create table t1 (a varchar(10) charset utf8mb4, b int, c int); +insert t1 values (1,2,3),(4,5,6),(1,7,8); +select concat(a,":",group_concat(b)) from t1 group by a; +concat(a,":",group_concat(b)) +1:2,7 +4:5 +drop table t1; +# # End of 10.3 tests # |