diff options
| author | ram@gw.mysql.r18.ru <> | 2004-06-21 14:11:51 +0500 |
|---|---|---|
| committer | ram@gw.mysql.r18.ru <> | 2004-06-21 14:11:51 +0500 |
| commit | 1d3118f1d28b09ab19e7eedb8cbe203cf5f84106 (patch) | |
| tree | 9aab0976e782eec69b3f4aad0de2b80df30eeac9 /mysql-test/r | |
| parent | 862a6ed4ca11377abffd6443e48180a62ebcdfce (diff) | |
| download | mariadb-git-1d3118f1d28b09ab19e7eedb8cbe203cf5f84106.tar.gz | |
proper test of warnings for group_concat().
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/func_gconcat.result | 7 |
1 files changed, 5 insertions, 2 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 |