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

tis620: Sortlen is too large

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 5.1.67, 5.2.14, 5.5.34, 10.0.6
    • 10.2
    • None
    • None

    Description

      "Sortlen" reports "4" for tis620_thai_ci in this query:

      mysql> show collation like 'tis620_thai_ci';
      +----------------+---------+----+---------+----------+---------+
      | Collation      | Charset | Id | Default | Compiled | Sortlen |
      +----------------+---------+----+---------+----------+---------+
      | tis620_thai_ci | tis620  | 18 | Yes     | Yes      |       4 |
      +----------------+---------+----+---------+----------+---------+
      1 row in set (0.00 sec)

      "Sortlen" comes from the "strxfrm_multiply" member
      of my_charset_tis620_thai_ci.

      The code in strings/ctype-tis620.c does not really look like
      the weight string for tis620_thai_ci can grow four times comparing
      to the original text string. strxfrm_multiply=1 should be enough.

      A too large strxfrm_multiply (Sortlen) value affects performance
      of non-indexed ORDER BY negatively.

      Attachments

        Activity

          People

            bar Alexander Barkov
            bar Alexander Barkov
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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