Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-5240

MariaDB 10.3. leads to error when using DataType TEXT

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • Icebox
    • None
    • None
    • Mariadb 10.3.16 1.2.5.1 on RHEL 7

    Description

      Affected are all versions running on MariaDB 10.3. having a Column as TEXT datatype

      The error that occurs is:

      Error Code: 1815. Internal error: IDB-2015: Sorting length exceeded. Session variable max_length_for_sort_data needs to be set higher.
      The problem appears as soon as the "Rückmeldung-Inhalt" field is dragged to the report or trying to filter on this field.
      

      The variable max_length_for_sort_data was checked by:
      by

      show global variables like '%max_length%'; 
      

      and WAS 102400, then set to something > 8.000.000 (the actual allowed maximum), but this didn't help.

      The problem is the ORDER BY. Leaving it out works. (This time, the HAVING and GROUP BY are not the problem.)

      It was verified also on ILS Nürnberg and our internal test servers that the version 10.3. is the problem; with 10.5. it works.
      Problem is with 10.3 works with MariaDB Version 10.5.

      However, we changed to TEXT because MariaDB 10.5. has the problem of:
      Internal error: CAL0009: (3)Create table failed due to char, varchar and varbinary length may not exceed 8000.

      Attachments

        Activity

          People

            Unassigned Unassigned
            aeae81 andreas eschbacher
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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