Skip to content

Instantly share code, notes, and snippets.

@elenst
Created March 22, 2017 15:16
Show Gist options
  • Save elenst/ee71cda608851678e41881beccee0ee7 to your computer and use it in GitHub Desktop.
Save elenst/ee71cda608851678e41881beccee0ee7 to your computer and use it in GitHub Desktop.
MariaDB [test]> create table t20 (pk int primary key, a int, key GEN_CLUST_INDEX(a)) engine=innodb;
ERROR 1280 (42000): Incorrect index name 'GEN_CLUST_INDEX'
MariaDB [test]> show warnings;
+---------+------+-------------------------------------------------------------------------------------------------------------+
| Level | Code | Message |
+---------+------+-------------------------------------------------------------------------------------------------------------+
| Warning | 1280 | Cannot Create Index with name 'GEN_CLUST_INDEX'. The name is reserved for the system default primary index. |
| Error | 1280 | Incorrect index name 'GEN_CLUST_INDEX' |
| Warning | 1030 | Got error -1 "Internal error < 0 (Not system error)" from storage engine InnoDB |
+---------+------+-------------------------------------------------------------------------------------------------------------+
3 rows in set (0.00 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment