List:Commits« Previous MessageNext Message »
From:Dmitry Shulga Date:November 25 2010 10:47am
Subject:bzr commit into mysql-5.1-bugteam branch (Dmitry.Shulga:3521) Bug#56473
View as plain text  
#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


Attachment: [text/bzr-bundle] bzr/dmitry.shulga@oracle.com-20101125104657-b24lnkji95hrc9iz.bundle
Thread
bzr commit into mysql-5.1-bugteam branch (Dmitry.Shulga:3521) Bug#56473Dmitry Shulga25 Nov
  • Re: bzr commit into mysql-5.1-bugteam branch (Dmitry.Shulga:3521)Bug#56473Davi Arnaut25 Nov