[MDEV-5542] GROUP_CONCAT truncate output to 65.536 chars when using DISTINCT or ORDER BY - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 5.5(EOL), 10.0(EOL), 10.1(EOL)
Fix Version/s: 10.1.13
Component/s: OTHER
Labels:
- upstream-fixed

Description

As in the summary, I try to GROUP_CONCAT a LONGTEXT field; result is fine if I don'use DISTINCT or ORDER BY as options for the GROUP BY function, otherwise the result is truncated to 65.536 chars (maybe the result is VARCHAR?).
I've already set the variable group_concat_max_len to 100.000.000.
However the query return a warning of the result will be truncated.

Attachments

Activity

People

Assignee:: Oleksandr Byelkin

Reporter:: Risato Stefano

Votes:: 0 Vote for this issue

Watchers:: 7 Start watching this issue

Dates

Created:: 2014-01-20 13:12

Updated:: 2016-03-02 12:34

Resolved:: 2016-03-02 12:34

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.