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

SHOW CREATE TABLE does not consistently display ignored index status

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 10.6.0
    • N/A
    • N/A

    Description

       
      CREATE OR REPLACE TABLE t1 (id INT PRIMARY KEY, b INT, KEY k1(b) IGNORED);
       
      SHOW INDEXES FROM t1\G
      *************************** 1. row ***************************
              Table: t1
         Non_unique: 0
           Key_name: PRIMARY
       Seq_in_index: 1
        Column_name: id
          Collation: A
        Cardinality: 0
           Sub_part: NULL
             Packed: NULL
               Null: 
         Index_type: BTREE
            Comment: 
      Index_comment: 
            Ignored: NO
      *************************** 2. row ***************************
              Table: t1
         Non_unique: 1
           Key_name: k1
       Seq_in_index: 1
        Column_name: b
          Collation: A
        Cardinality: 0
           Sub_part: NULL
             Packed: NULL
               Null: YES
         Index_type: BTREE
            Comment: 
      Index_comment: 
            Ignored: YES
       
      SHOW CREATE TABLE t1;
      +-------+-------------------------------------------------------------------------------------------------------------------+
      | Table | Create Table                                                                                                      |
      +-------+-------------------------------------------------------------------------------------------------------------------+
      | t1    | CREATE TABLE "t1" (
        "id" int(11) NOT NULL,
        "b" int(11) DEFAULT NULL,
        PRIMARY KEY ("id"),
        KEY "k1" ("b")
      ) |
      +-------+-------------------------------------------------------------------------------------------------------------------+
      

      This doesn't appear to affect all environments - I tested this with http://hasky.askmonty.org/archive/10.6/build-39581/kvm-bintar-trusty-amd64/

      Attachments

        Activity

          People

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