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

Description says invisible rather than ignore

    XMLWordPrintable

Details

    • Notable changes

    Description

      The manual description of ALTER TABLE https://mariadb.com/kb/en/alter-table/
      has a line

         |  ALTER {INDEX|KEY} index_name [NOT] INVISIBLE
      

      but that's MySQL. Correct is

        | ALTER {INDEX|KEY} [IF EXISTS] index_name [NOT] IGNORED
      

      By the way: VISIBLE is listed under index_option but that only is okay for ALTER ... ADD or for CREATE.
      So I can say
      CREATE TABLE t2 (s1 INT, INDEX i (s1) VISIBLE IGNORED);
      but that's not a problem because MariaDB allows contradictions.

      Attachments

        Activity

          People

            greenman Ian Gilfillan
            Peter Gulutzan Peter Gulutzan
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.