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

Incorrect ordering with utf8_bin and utf8mb4_bin collations

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.0.10
    • Fix Version/s: 10.0.11
    • Component/s: None
    • Labels:

      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

            People

            Assignee:
            bar Alexander Barkov
            Reporter:
            jeremycole Jeremy Cole
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: