Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Index adds comment keyword and then does not display index in software #732

Closed
sowork opened this issue Aug 7, 2019 · 1 comment

Comments

@sowork
Copy link

commented Aug 7, 2019

  1. Create a table
CREATE TABLE IF NOT EXISTS `test` (
  `str` varchar(50) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1. Add an index
ALTER TABLE `test` 
 ADD INDEX `idx_str`(`str`) USING hash COMMENT 'xxxxxxx';

Current behavior

No index is visible in the software

Expected behavior

Ability to view indexes in software

Environment

heidisql version: 10.2.0.5599
mysql version: 5.7
operating system: Microsoft Windows [版本 10.0.18945.1001]

@ansgarbecker ansgarbecker added this to the v10.3 milestone Aug 11, 2019

@ansgarbecker

This comment has been minimized.

Copy link
Collaborator

commented Aug 11, 2019

Index comments are apparently a new feature in MySQL?
The next build should at least display such indexes. Please update and report back.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
2 participants
You can’t perform that action at this time.