Bug #23856 GROUP_CONCAT and ORDER BY: junk from previous rows for query on I_S
Submitted: 1 Nov 2006 22:06 Modified: 7 Jun 2007 18:25
Reporter: Roland Bouman
Status: Closed
Category:Server Severity:S2 (Serious)
Version:5.1.13bk, 5.0 BK OS:Linux (Linux)
Assigned to: Martin Hansson Target Version:
Tags: order by, group_concat

File: Maximum allowed size is 500KB.
Description:
Privacy:

If the data you need to attach is more than 500KB, you should create a compressed archive of the data and a README file that describes the data with a filename that includes the bug number (example: bug-data-23856.zip), and use FTP to upload the archive to ftp://ftp.mysql.com/pub/mysql/upload/. Once you have uploaded the file, add a comment to this bug to notify us about it. Note: This directory is unlistable, which means that once you have uploaded your file, you will not be able to see it.

All entries become the exclusive editorial property of Sun Microsystems, Inc.

[2 Nov 2006 14:09] Roland Bouman 
My /etc/my.cnf

Attachment: my.cnf (application/octet-stream, text), 17.66 KiB.
[17 Feb 2007 20:17] Pete Harlan 
Another script that reproduces the group_concat_max_len problem

Attachment: bugreport.sql (text/x-sql), 2.19 KiB.