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

Allow for database name to prefix index name in CREATE INDEX statement

Details

    Description

      Oracle supports prefixing the index name in CREATE INDEX with the database name, MariaDB does not. For compatibility it would be reasonable to support this syntax, even if it is ignored, in SQL_MODE=Oracle. Two different SQL_MODE options would be reasonable
      IGNORE_INDEX_DBNAME - Always ignore the database name.
      IGNORE_INDEX_SAMEDBNAME - Ignore database name if it matches the table name, else raise an error.

      Attachments

        Activity

          karlsson Anders Karlsson created issue -

          People

            Unassigned Unassigned
            karlsson Anders Karlsson
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.