diff options
| author | unknown <ram@gw.mysql.r18.ru> | 2004-06-21 14:11:51 +0500 |
|---|---|---|
| committer | unknown <ram@gw.mysql.r18.ru> | 2004-06-21 14:11:51 +0500 |
| commit | e3b3720e5f49dc948f7a67d14a8c14fd3c48df6f (patch) | |
| tree | 9aab0976e782eec69b3f4aad0de2b80df30eeac9 | |
| parent | a765bf8c16272c71552e16570c8ed1856c71d088 (diff) | |
| download | mariadb-git-e3b3720e5f49dc948f7a67d14a8c14fd3c48df6f.tar.gz | |
proper test of warnings for group_concat().
| -rw-r--r-- | mysql-test/r/func_gconcat.result | 7 | ||||
| -rw-r--r-- | mysql-test/t/func_gconcat.test | 2 |
2 files changed, 6 insertions, 3 deletions
diff --git a/mysql-test/r/func_gconcat.result b/mysql-test/r/func_gconcat.result index 0c744d1dff6..0c8054c1f03 100644 --- a/mysql-test/r/func_gconcat.result +++ b/mysql-test/r/func_gconcat.result @@ -149,16 +149,19 @@ grp group_concat(c order by c) 3 D,D,E 4 5 NULL -set group_concat_max_len = 5; +set group_concat_max_len = 4; select grp,group_concat(c) from t1 group by grp; grp group_concat(c) 1 NULL 2 b -3 D,D,E +3 D,D, 4 5 NULL +Warnings: +Warning 1260 1 line(s) were cut by GROUP_CONCAT() show warnings; Level Code Message +Warning 1260 1 line(s) were cut by GROUP_CONCAT() set group_concat_max_len = 1024; select group_concat(sum(a)) from t1 group by grp; ERROR HY000: Invalid use of group function diff --git a/mysql-test/t/func_gconcat.test b/mysql-test/t/func_gconcat.test index 5ddc93e767b..62343fa2af8 100644 --- a/mysql-test/t/func_gconcat.test +++ b/mysql-test/t/func_gconcat.test @@ -61,7 +61,7 @@ select grp,group_concat(c order by c) from t1 group by grp; # Test warnings -set group_concat_max_len = 5; +set group_concat_max_len = 4; select grp,group_concat(c) from t1 group by grp; show warnings; set group_concat_max_len = 1024; |