From: Dmitry Shulga
Date: November 25 2010 10:47am
Subject: bzr commit into mysql-5.1-bugteam branch (Dmitry.Shulga:3521) Bug#56473
List-Archive: http://lists.mysql.com/commits/125004
X-Bug: 56473
Message-Id: <201011251047.oAP8GDkE009027@acsinet15.oracle.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============1117649485=="

--===============1117649485==
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

#At file:///Users/shulga/projects/mysql/5.1-bugteam-bug56473/ based on revid:azundris@stripped

 3521 Dmitry Shulga	2010-11-25
      Bug#56473: ERROR 1260 (HY000): %d line(s) were cut by GROUP_CONCAT().
      Adding a test case to ensure there will be no regression.

    modified:
      mysql-test/r/group_by.result
      mysql-test/t/group_by.test
=== modified file 'mysql-test/r/group_by.result'
--- a/mysql-test/r/group_by.result	2010-07-30 13:35:06 +0000
+++ b/mysql-test/r/group_by.result	2010-11-25 10:46:57 +0000
@@ -1845,4 +1845,20 @@ SELECT SUBSTRING(a,1,10), LENGTH(a) FROM
 SUBSTRING(a,1,10)	LENGTH(a)
 1111111111	1300
 DROP TABLE t1;
+#
+# Bug#56473: too long output from group_concat()
+# results in: "ERROR 1260 (HY000): %d line(s) were cut by GROUP_CONCAT()"
+#
+SET @@group_concat_max_len = 10;
+DROP TABLE IF EXISTS t1;
+CREATE TABLE t1 (c1 text);
+INSERT INTO t1 VALUES
+(REPEAT('a', 20));
+SELECT GROUP_CONCAT(c1) FROM t1;
+GROUP_CONCAT(c1)
+aaaaaaaaaa
+Warnings:
+Warning	1260	1 line(s) were cut by GROUP_CONCAT()
+DROP TABLE t1;
+SET @@group_concat_max_len = 1024;
 # End of 5.1 tests

=== modified file 'mysql-test/t/group_by.test'
--- a/mysql-test/t/group_by.test	2010-07-30 13:35:06 +0000
+++ b/mysql-test/t/group_by.test	2010-11-25 10:46:57 +0000
@@ -1236,4 +1236,19 @@ SELECT SUBSTRING(a,1,10), LENGTH(a) FROM
 DROP TABLE t1;
 
 
+--echo #
+--echo # Bug#56473: too long output from group_concat()
+--echo # results in: "ERROR 1260 (HY000): %d line(s) were cut by GROUP_CONCAT()"
+--echo #
+SET @@group_concat_max_len = 10;
+--disable_warnings
+DROP TABLE IF EXISTS t1;
+--enable_warnings
+CREATE TABLE t1 (c1 text);
+INSERT INTO t1 VALUES
+       (REPEAT('a', 20));
+SELECT GROUP_CONCAT(c1) FROM t1;
+DROP TABLE t1;
+SET @@group_concat_max_len = 1024;
+
 --echo # End of 5.1 tests


--===============1117649485==
MIME-Version: 1.0
Content-Type: text/bzr-bundle; charset="us-ascii";
	name="bzr/dmitry.shulga@stripped"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

# Bazaar merge directive format 2 (Bazaar 0.90)
# revision_id: dmitry.shulga@stripped\
#   b24lnkji95hrc9iz
# target_branch: file:///Users/shulga/projects/mysql/5.1-bugteam-\
#   bug56473/
# testament_sha1: 8e6ec25cf8baa14150562290e0f129942722008b
# timestamp: 2010-11-25 16:47:11 +0600
# base_revision_id: azundris@stripped
# 
# Begin bundle
IyBCYXphYXIgcmV2aXNpb24gYnVuZGxlIHY0CiMKQlpoOTFBWSZTWXAnjb4AAsJfgAkwWuf//3/n
3+C////wYAYvgAAAAAAAERTZTIMhkA9E9EDQBkZAeoGmgADjJk0YhiaYCBgTTBGCYmmmgAwhxkya
MQxNMBAwJpgjBMTTTQAYQ4yZNGIYmmAgYE0wRgmJppoAMIcZMmjEMTTAQMCaYIwTE000AGEEkhAC
ZMJkBMhqbQmg00mp+o0YmQyn6TITRPQzTMcJhJEf4Eeq5oD0aVYk05SlIoJoYJSvJRjBIYhSQtaY
WgqDhM/o6LB+jWnUGgGWpZ1cfwPGGZmP8+arPKKTrBnWsZ/FSjy3qIo2hz0h+oaTP3mk/IRHsGHf
sPGM51fXBH0DUx9ZoH2OXEncpTcTUH3eQuHKs+J1nwHmVJGFBiaAcxr4Wdt50Q2+c+ruIP6hwjqc
MMzaUytPA4FIwQXrkcPTWhGcW0LcDjMMynMDwKBPDehd67jsA0EKfaKTEOx2s+3VQdVnNbXHoKEy
Bu4eJZD3QNxQESRnm9Qyfncv8UAcD4iOCE5IgDNgaw9ZFEWSkTwHofFIMUk2RMylQ3TQfaaJ5TmR
kMmPdxR+nKZCokLQPUbXmmNIcnw8xriCIoLEh1TLCmPFrYM4zL99RUDjyrokBsnLRhAztzaysuRk
LMVGLBA15tb6DggK++bDNIBaV7QHgFMZia1CANcyLCydx5QpfPNRQOJTUSTyhMWMpTa6BdWPKFhj
A3bb46xl23DrAoWDVwLImW3SozCTNFeQAYuvDapTOriz/R9hcRZ0wExK8xGwljVwwFasqH2GIZFI
exZVaLAHXmh2g0kR+bc3Ew2G5ZAZEvnMdphVUtRpCDOjLSyA8DeQAea4cJNo/LSFVJEO1E6oJQI3
XLdQPC/8FVu5T53UvIrA6jPPeVjWbw6DMZyFQVW9OFdRITDHFby/QpIr844wtcVwzmd5mI487FoG
KjKCa0sAyWvecloUll7lW1qsyfUQiHRucoOBo2gpERyM8hEMxMDHP2pgzPwGzGLxg6fgeeUPkHWa
0GheoXke0+iTGdZgZm+gn91J/9L8JRkQwRf35FIwfE+ZS8+A80FTz7jA4+4wqWP3TDhj8HoFYXHz
QShYVGCTCUAjKknKBSf0eQSL7pSpTFZkMFJZ4RhSTFaCITEpaXliURQTH+rFLxBdPmNSX7A5G/+X
Igc/tq+Z+hIL2eHsKO88CFNCCkv8c81vySHSuKh7keMIy6E8qX4/I36+xhmBsGDt9Kf8QPjmPdaY
++4+Ju95FWbaT4GBY8lD3CnNR4m1J3gjgfxVzjG4CjeK5fW0kIYaQvcyR6xLC8UZCgM0v5TvgX33
EdU4RB/Lnor7/fZX5lv8jbyNfyJkxNUqpdgfM1uwaMIIV55+jA09T8CKOB0yRkZ5zsJIjBnUE6GK
+6OMxCnHIk3c/TnbdKaNHXfdK1H5cXBZ0zrkmDQW0YegMeW3o37KJROcIck7m1hpNJzQUDEyO0kh
sIuZdRmXyORqKd7jjicw8fYaSMNK/pr0bxHHUyJhxcb+Gbk4Zis+gZlVsN4qebiQCnOB4yANkjiS
lnpP7AvYau30oaTkuAtbzQtaNYVzysmPVvyivF7SxSYo5JDG45JSDVd+4sA1E5q2G06V27EYgRdx
XmmByHTvDqKEhgzk4ViNQcYsoWARDlcUuNm6/0pKhtSqB5szHyLgNksca7lkc5NiEliY6yA5QvHC
n4kSJEwQZMMpbAvAlgTJMwMt1/YGic3RE62JKUTC5qSUiOtIcikpXoepFTslBVmYy3iyLwUWlhgi
U1MUGpKjkOwoN0Rp3XKlIxGRwmAgFLWSpT86eV87lHONTvT1MFlZFbSClkjYZAzxx1BePtUHuvvY
mmpsW5qi0CaZgecKTOx2nrZm5ypBQhkcydsr0hmY3uech48rj1COWpSwGCOUGOgdqtm0KkcJmln4
VjoKhFKrKnYiJyZ4PyGOwy5/BdBzHQI56wOKtBOvbOHAgMMYmdXS7UTnm2mQRDeY0EuNgdZQleGk
GTAMmYrGMxpNBQlA7FO8KZ+5QV3mP+F3JFOFCQcCeNvg


--===============1117649485==--