Incorrect timestamp null on alter table in MySQL

[raqua]

Column is defined in table as:
`LAST_UNSUCCESSFUL_LOGIN_TIME` timestamp NULL DEFAULT NULL

Generated alter table fails. It looks like this:
ALTER TABLE `USER` MODIFY COLUMN LAST_UNSUCCESSFUL_LOGIN_TIME timestamp COMMENT 'Timestamp of last unsuccessful login attempt';

but should be

ALTER TABLE `USER` MODIFY COLUMN LAST_UNSUCCESSFUL_LOGIN_TIME timestamp NULL COMMENT 'Timestamp of last unsuccessful login attempt';

[Serge]

This issue will be fixed in the next version.
Thanks for report.

[raqua]

This is probably related, so I am putting it here instead of separate post.

ALTER TABLE schema.table MODIFY COLUMN START_TIME timestamp NOT NULL DEFAULT 0000-00-00 00:00:00 COMMENT 'Campaign start';
Should be
ALTER TABLE schema.table MODIFY COLUMN START_TIME timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Campaign start';

Quotes are missing on default timestamp.

[Serge]

This is also a bug. Will be fixed in the next version.
Thanks for report!

[raqua]

Found another one:

ALTER TABLE schema.table MODIFY COLUMN AGE_CHECKED tinyint COMMENT '....';

should be:

ALTER TABLE schema.table MODIFY COLUMN AGE_CHECKED tinyint(1) COMMENT '....';

[Serge]

That's a different issue.
Currently DBeaver doesn't support MySQL numeric columns "display width" attributes. These attributes mostly used for plain-text output formatting. Maybe that's the main reason why they are not yet supported.

Actually I'm thinking about redesign of column type editor. Current one isn't flexible enough.
Anyhow I'll try to handle this problem somehow..