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

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

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration