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

Order by with UTF

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.2, 1.4
    • 1.5.2
    • ExeMgr
    • None
    • 2019-06, 2020-1, 2020-2, 2020-3, 2020-4, 2020-5, 2020-6, 2020-7

    Description

      We now use the internal ORDER BY of columnstore rather than relying on Server to do the ORDER BY. However, our current collation doesn't allow for anything other than Latin-1.

      A means of getting the collation type from the table and passing it to the collation step must be created. Then the sort itself must be made to use it. In addition, the WINDOW FUNCTION ORDER BY must use this same collation.

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4620 Function within an aggregate can cause crash (assert) on Ubuntu 20.02

          • Major - Major loss of function.
          • Closed
          is blocked by

          Task - A task that needs to be done. MDEV-21504 Collation: Create shared library for engines to use

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

          New Feature - A new feature of the product, which has yet to be developed. MCOL-2178 Run CS with vanilla 10.4

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

          Bug - A problem which impairs or prevents the functions of the product. MCOL-2221 reverse function not work properly with non-latin chars

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4498 LIKE is not collation aware

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

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4064 Make JOIN collation aware

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

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4065 DISTINCT is case sensitive

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

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4085 ALTER TABLE MODIFY COLUMN COLLATE syntax error

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4099 Function Insert not inserting.

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4100 functions LOCATE, INSTR, STRCMP and FIND_IN_SET are case sensitve

          • Major - Major loss of function.
          • Closed

          Activity

            People

              dleeyh Daniel Lee (Inactive)
              David.Hall David Hall (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 5d Original Estimate - 5d
                  5d
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 17d
                  17d

                  Git Integration

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