Bug #86123 EER designer lacks fractional-second-part for DATETIME type
Submitted: 28 Apr 2017 1:40 Modified: 28 Apr 2017 2:21
Reporter: Ian Young Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S2 (Serious)
Version:6.3.9 OS:MacOS (macOS 10.12.x Sierra x86_64)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[28 Apr 2017 1:40] Ian Young 
Description:
The table designer lacks support for DATETIME([fsp]) column definitions. 

(in addition the trigger designer marks SET new.colname = NOW([fsp]) as a syntax error)

How to repeat:
attempt to create a 5.7-compatible table whose datetime definition features a precision (e.g.: DATETIME(6))

Suggested fix:
add support for validating fractional DATETIME columns/functions.
[28 Apr 2017 2:08] MySQL Verification Team 
On Windows

Attachment: 00000_datetime(6).png (image/png, text), 141.56 KiB.
[28 Apr 2017 2:18] MySQL Verification Team 
On MAC OSX Sierra

Attachment: 000000000datetime(6)onmac.png (image/png, text), 367.08 KiB.
[28 Apr 2017 2:21] MySQL Verification Team 
Thank you for the bug report. Please see prior screenshot difference between Windows and MAC was on MAC I needed to type (6).