-
-
Notifications
You must be signed in to change notification settings - Fork 563
Indexes with comments are ignored #128
Copy link
Copy link
Closed
Labels
bugDefective behaviour in HeidiSQLDefective behaviour in HeidiSQLconfirmedIssue verified by project memberIssue verified by project membernettype-mysqlMySQL and/or MariaDB specific issueMySQL and/or MariaDB specific issue
Milestone
Description
Expected behavior
Index with comment is visible in "Indexes" tab.
Current behavior
Index with comment is not visible in "Indexes" tab.
Failure information
Indexes with comments are ignored by HeidiSQL. They are not visible in "Indexes" and "CREATE code" tab.
Steps to reproduce
- Create table:
CREATE TABLE `index_test` (
`nr1` int,
`nr2` int,
KEY `hidden_index` (`nr1`) COMMENT 'some comment',
KEY `visible_index` (`nr2`)
);
- Check if both indexes are created with
SHOW CREATE TABLE index_test;:
CREATE TABLE `index_test` (
`nr1` int(11) DEFAULT NULL,
`nr2` int(11) DEFAULT NULL,
KEY `hidden_index` (`nr1`) COMMENT 'some comment',
KEY `visible_index` (`nr2`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
Context
- HeidiSQL version: 9.5.0.5196 (64 Bit)
- Database system + version: MariaDB 10.1.11
- Operating system: Windows 10
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
bugDefective behaviour in HeidiSQLDefective behaviour in HeidiSQLconfirmedIssue verified by project memberIssue verified by project membernettype-mysqlMySQL and/or MariaDB specific issueMySQL and/or MariaDB specific issue

