Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-5542

GROUP_CONCAT truncate output to 65.536 chars when using DISTINCT or ORDER BY

    XMLWordPrintable

Details

    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

            sanja Oleksandr Byelkin
            steris Risato Stefano
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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