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

Incorrect ordering with utf8_bin and utf8mb4_bin collations

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

        Activity

          Ascending order - Click to sort in descending order
          jeremycole Jeremy Cole created issue -
          elenst Elena Stepanova made changes -
          Field Original Value New Value
          Fix Version/s 10.0.11 [ 15200 ]
          elenst Elena Stepanova made changes -
          Assignee Alexander Barkov [ bar ]
          elenst Elena Stepanova made changes -
          bar Alexander Barkov made changes -
          Resolution Fixed [ 1 ]
          Status Open [ 1 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow defaullt [ 39816 ] MariaDB v2 [ 42917 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Workflow MariaDB v2 [ 42917 ] MariaDB v3 [ 61944 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 61944 ] MariaDB v4 [ 147838 ]

          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.