MySQL Bugs: #81123: Fractional part of seconds missing in table editor

Bug #81123	Fractional part of seconds missing in table editor
Submitted:	18 Apr 2016 9:58	Modified:	18 Apr 2016 11:15
Reporter:	Matthias Maier	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S3 (Non-critical)
Version:	6.3.6	OS:	Windows (Windows 7 Enterprise Service Pack 1)
Assigned to:		CPU Architecture:	Any
Tags:	ALTER TABLE, fractional seconds, MICROSECOND

Description:
The table editor does not show the fractional part of seconds. It is not possible to distinguish date/time datatypes with and without fractional seconds in the editor.

How to repeat:
CREATE TABLE `test`.`new_table` (
  `col1` TIME(6) NULL,
  `col2` DATETIME(6) NULL,
  `col3` TIMESTAMP(6) NULL);

Open table editor and look at datatype for missing fractional part.

Suggested fix:
Represent the fractional part of seconds in table editor, like "type_name(fsp)". This is already done for other non date/time datatypes.

(see also https://dev.mysql.com/doc/refman/5.6/en/fractional-seconds.html)

Missing fractional seconds in table editor

Attachment: Fractional_Seconds.png (image/png, text), 24.53 KiB.

Hello Matthias,

Thank you for the report.

Thanks,
Umesh

Fractional seconds in time values are supported since MySQL 5.6.4 (see https://dev.mysql.com/doc/refman/5.6/en/fractional-seconds.html) and this bug is already opened for three years. I haven't had the need to design tables in Workbench with this feature until now, so I hope it's fixed in next releases.