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

Ignorable index makes the resulting CREATE TABLE invalid

    XMLWordPrintable

    Details

      Description

      The syntax for creating an ignorable index, according to MDEV_7317, is KEY .. IGNORE. However, the resulting SHOW CREATE TABLE shows "IGNORED" instead, and an attempt to use it causes a syntax error:

      10.6 03ff588d1

      MariaDB [test]> CREATE TABLE t (a INT, KEY (a) IGNORE);
      Query OK, 0 rows affected (0.046 sec)
       
      MariaDB [test]> SHOW CREATE TABLE t;
      +-------+---------------------------------------------------------------------------------------------------------------+
      | Table | Create Table                                                                                                  |
      +-------+---------------------------------------------------------------------------------------------------------------+
      | t     | CREATE TABLE `t` (
        `a` int(11) DEFAULT NULL,
        KEY `a` (`a`) IGNORED
      ) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
      +-------+---------------------------------------------------------------------------------------------------------------+
      1 row in set (0.001 sec)
      

      MariaDB [test]> DROP TABLE t;
      Query OK, 0 rows affected (0.031 sec)
       
      MariaDB [test]> CREATE TABLE `t` (
          ->   `a` int(11) DEFAULT NULL,
          ->   KEY `a` (`a`) IGNORED
          -> ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ;
      ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') ENGINE=InnoDB DEFAULT CHARSET=latin1' at line 4
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              psergey Sergei Petrunia
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: