[BUG] It does not display correctly 'COMMENT' of enum type

2 posts
[expired user #8620]'s profile image [expired user #8620] posted 9 years ago in General Permalink

Create a table by test

CREATE TABLE `table` (
`sex` ENUM('Y','N') NOT NULL COMMENT 'my comment'
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB;



Now, let's add a default value.

ALTER TABLE `table`
CHANGE COLUMN `sex` `sex` ENUM('Y','N') NOT NULL DEFAULT 'Y' COMMENT 'my comment' FIRST;


You can't see COMMENT. but I can see it by mysql commmand.

mysql> show create table `table`
2 posts
[expired user #8620]'s profile image [expired user #8620] posted 9 years ago Permalink
BTW:

HeidiSQL 9.1.0.4894(64 Bit)
Code modification/commit from ansgar.becker, 9 years ago, revision 9.1.0.4895
ExtractLiteral deletes required characters from input string. Don't delete more from a regex detection. Broken in r4893. See http://www.heidisql.com/forum.php?t=17399
10167 posts
ansgar's profile image ansgar posted 9 years ago Permalink
Confirmed. That was broken in r4893. Just fixed in r4895.

Please login to leave a reply, or register at first.