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

CREATE UNIQUE INDEX USING HASH malfunctions for engine=Aria table

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 10.4.11
    • N/A
    • N/A
    • None
    • 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

              Unassigned Unassigned
              mrigger Manuel Rigger
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.