Skip to content

Indexes with comments are ignored #128

@dzintb

Description

@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`)
);
  1. 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
  1. Check "Indexes" tab:
    1

  2. Check "CREATE code" tab:
    2

Context

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugDefective behaviour in HeidiSQLconfirmedIssue verified by project membernettype-mysqlMySQL and/or MariaDB specific issue

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions