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

CREATE UNIQUE INDEX USING HASH malfunctions for engine=Aria table

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 10.4.11
    • Fix Version/s: N/A
    • Component/s: N/A
    • Labels:
      None
    • Environment:
      Ubuntu 19.04

      Description

      On a recent trunk version (0308de9), the creation of the following index seems to malfunction:

      CREATE TABLE t0(c0 INT) engine=Aria;
      CREATE UNIQUE INDEX i0 USING HASH ON t0(c0); -- Key/Index cannot be defined on a virtual generated column
      

      This error is not triggered if the index is not unique, or when "USING HASH" is not used. The error seems unexpected, because from a user perspective, no virtual generated column is involved.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              mrigger Manuel Rigger
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: