Broken table editor

kalvaro's profile image kalvaro posted 12 years ago in General Permalink
Latest nightly. When I run this query:

SHOW CREATE TABLE stay_signed_in


... I get back the correct code for my table:

CREATE TABLE `stay_signed_in` (
`id_stay_signed_in` int(11) unsigned NOT NULL auto_increment,
`code` char(32) collate utf8_spanish2_ci NOT NULL COMMENT 'Código único que identifica el acceso guardado',
`id_user` int(11) NOT NULL,
`ipv4` int(10) unsigned NOT NULL COMMENT 'Dirección IP desde la que se ha generado la sesión',
`user_agent` varchar(500) collate utf8_spanish2_ci default NULL COMMENT 'Encabezado User-Agent',
`crt_user` varchar(10) collate utf8_spanish2_ci NOT NULL,
`crt_date` datetime NOT NULL,
`crt_process` varchar(255) collate utf8_spanish2_ci NOT NULL,
`upd_date` datetime default NULL,
`upd_process` varchar(255) collate utf8_spanish2_ci default NULL,
PRIMARY KEY  (`id_stay_signed_in`),
UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish2_ci


However, the table editor looks like this:



Link to full size: http://img844.imageshack.us/img844/215/heidisqlcommentcommentc.png

See that the column comments are copied to all columns.

The "CREATE code" tab shows this:

CREATE TABLE `stay_signed_in` (
`id_stay_signed_in` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`code` CHAR(32) NOT NULL COMMENT 'Código único que identifica el acceso guardado' COLLATE 'utf8_spanish2_ci',
`id_user` INT(11) NOT NULL COMMENT 'Código único que identifica el acceso guardado',
`ipv4` INT(10) UNSIGNED NOT NULL COMMENT 'Dirección IP desde la que se ha generado la sesión',
`user_agent` VARCHAR(500) NULL DEFAULT NULL COMMENT 'Encabezado User-Agent' COLLATE 'utf8_spanish2_ci',
`crt_user` VARCHAR(10) NOT NULL COMMENT 'Encabezado User-Agent' COLLATE 'utf8_spanish2_ci',
`crt_date` DATETIME NOT NULL COMMENT 'Encabezado User-Agent',
`crt_process` VARCHAR(255) NOT NULL COMMENT 'Encabezado User-Agent' COLLATE 'utf8_spanish2_ci',
`upd_date` DATETIME NULL DEFAULT NULL COMMENT 'Encabezado User-Agent',
`upd_process` VARCHAR(255) NULL DEFAULT NULL COMMENT 'Encabezado User-Agent' COLLATE 'utf8_spanish2_ci',
PRIMARY KEY (`id_stay_signed_in`),
UNIQUE INDEX `code` (`code`)
)
COLLATE='utf8_spanish2_ci'
ENGINE=InnoDB;


It must be an error in the parser routines. This was working fine the other day.
ansgar's profile image ansgar posted 12 years ago Permalink
Yes, obviously. I already suspected my new "ExtractComment" routine does not only do what it's supposed to do. Will check that.
Code modification/commit a3a42b5 from ansgar.becker, 12 years ago, revision 7.0.0.4385
Fix repeated column comment in table editor. See http://www.heidisql.com/forum.php?t=12540
ansgar's profile image ansgar posted 12 years ago Permalink
Fixed in r4385
kalvaro's profile image kalvaro posted 12 years ago Permalink
That was a blazing fast fix. Thanks a lot!

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