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

support longer then 8m rows in order by

    XMLWordPrintable

Details

    Description

      Without ha_calpont_impl_rnd_pos we are limited to a maximum of 8MB row length including blobs for sorting. For 1.0 this was fine but with BLOB/TEXT support this may not be enough.

      At the moment this function just returns the following error message:

      Sorting length exceeded. Session variable max_length_for_sort_data needs to be set higher.

      Attachments

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4735 Length may not exceed 8000 for utf8 varchar(2667) column

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MCOL-3879 ExeMgr crash on select - SELECT TABLE FROM -- WHERE scan_code = 'DUP' and id_datasource <> 1002;

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. MCOL-267 TEXT and BLOB data types are not supported

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Task - A task that needs to be done. MDEV-14500 filesort to support engines with slow rnd_pos

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            People

              toddstoffel Todd Stoffel (Inactive)
              LinuxJedi Andrew Hutchings (Inactive)
              Votes:
              3 Vote for this issue
              Watchers:
              10 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.