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

Hash index on partial char field not working

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 10.4.4
    • Component/s: Server
    • Labels:
      None

      Description

      eval create table t1 (
      c char(10),
      unique key a using hash (c(1))
      ) engine=myisam;
      show create table t1;
      insert into t1 values ('б');
      --error ER_DUP_ENTRY
      insert into t1 values ('бб');
      --error ER_DUP_ENTRY
      insert into t1 values ('ббб');
      drop table t1;
      
      

      mysqltest: At line 9: query 'insert into t1 values ('бб')' succeeded - should have failed with errno 1062...
      
      

      And also enable ctype_utf8mb4_innodb and myisam , which is disabled because of this bug.

        Attachments

          Activity

            People

            Assignee:
            sachin.setiya.007 Sachin Setiya
            Reporter:
            sachin.setiya.007 Sachin Setiya
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: