Indexes with comments are ignored

[dzintb]

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

1. Create table:

CREATE TABLE `index_test` (
  `nr1` int,
  `nr2` int,
  KEY `hidden_index` (`nr1`) COMMENT 'some comment',
  KEY `visible_index` (`nr2`)
);

2. 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

3. Check "Indexes" tab:
   

4. Check "CREATE code" tab:
   

Context

• HeidiSQL version: 9.5.0.5196 (64 Bit)
• Database system + version: MariaDB 10.1.11
• Operating system: Windows 10

[ansgarbecker]

Confirmed

[rentalhost]

Possible solution: create a new column like Comment on Index manager tab.

[blakesu]

encounter this issue too.

[ansgarbecker]

This issue is actually fixed - a commented index is no longer hidden. Just the comments are ignored.

[ansgarbecker]

Next build supports editing the comment of an index. However, you may need to activate the comment column first: