distal-attribute
distal-attribute
distal-attribute
distal-attribute

Broken table editor

User, date Message
Written by kalvaro
1 year ago
Category: General
591 posts since Thu, 29 Nov 07
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.
Written by ansgar
1 year ago
4967 posts since Fri, 07 Apr 06
Yes, obviously. I already suspected my new "ExtractComment" routine does not only do what it's supposed to do. Will check that.
Written by ansgar
1 year ago
4967 posts since Fri, 07 Apr 06
Fixed in r4385
Written by kalvaro
1 year ago
591 posts since Thu, 29 Nov 07
That was a blazing fast fix. Thanks a lot!
 

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