From e3b3720e5f49dc948f7a67d14a8c14fd3c48df6f Mon Sep 17 00:00:00 2001 From: unknown Date: Mon, 21 Jun 2004 14:11:51 +0500 Subject: proper test of warnings for group_concat(). --- mysql-test/r/func_gconcat.result | 7 +++++-- 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; -- cgit v1.2.1