Bug #67580 | group_concat() limited to 64kb on compress()'ed fields when order by is used | ||
---|---|---|---|
Submitted: | 13 Nov 2012 21:57 | Modified: | 13 Feb 2018 22:53 |
Reporter: | Aleksander Kamenik | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: DML | Severity: | S3 (Non-critical) |
Version: | 5.5.28, 5.5.30, 5.1.67, 5.0.97 | OS: | Linux (sles11) |
Assigned to: | CPU Architecture: | Any | |
Tags: | 64, compress(), group_concat(), limit, order by, uncompress() |
[13 Nov 2012 21:57]
Aleksander Kamenik
[29 Nov 2012 19:18]
Sveta Smirnova
Thank you for the report. This was fixed in version 5.6. Please upgrade.
[30 Nov 2012 11:48]
Aleksander Kamenik
1. So you don't fix the current stable version (5.5)? I don't think upgrading to a development version in production is such a good idea. 2. Why is status set to "Can't repeat" if you acknowledge the bug and say it's fixed in 5.6? Can't the fix be backported?
[30 Nov 2012 12:40]
Sveta Smirnova
There is no bug fix for this, but we introduced many new optimizer features in version 5.6. I believe fix of this bug is result of these improvements. I can set this bug to "Verified in 5.5 and earlier versions", although I am not sure if these improvements could be easily backported. But if you have Oracle support contract you can open a SR and request backport.
[13 Feb 2018 22:53]
Roy Lyseng
Posted by developer: Fixed in 5.6, according to comments.