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

Incorrect ordering with utf8_bin and utf8mb4_bin collations

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.0.10
    • 10.0.11
    • None

    Description

      In MySQL 5.6 the utf8_bin and utf8mb4_bin collations were broken such that they ordered by only the high byte of the utf8 character (meaning ASCII sorts as though all characters were 0, resulting in random sort). This was fixed in the following commit (and maybe others):

      https://github.com/darnaut/mysql-server/commit/5fe5a5b

      This issue affects MariaDB 10 as well. See the attached simple test for this sorting bug.

      Attachments

        1. sort_order_funny.result
          0.6 kB
          Jeremy Cole
        2. sort_order_funny.test
          0.5 kB
          Jeremy Cole

        Activity

          People

            bar Alexander Barkov
            jeremycole Jeremy Cole
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.