Bug #74254 Can't alter the number of fractional seconds digits in a column definition
Submitted: 7 Oct 2014 16:17 Modified: 11 Dec 2015 2:12
Reporter: Jim Flagg Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:6.2.3 OS:Any
Assigned to: CPU Architecture:Any
Tags: digits, fractional, SECONDS

[7 Oct 2014 16:17] Jim Flagg 
Description:
With Workbench connecting to an actual database I can't alter a table definition to change the number of fractional seconds digits after the table is created.

How to repeat:
Create a table with a datetime or time field.
In Workbench right-click the table name and select 'Alert Table'
Go to an existing datetime or time column and try to change the fractional seconds number of digits such as DATETIME(2) to DATETIME(3)
Click apply

Workbench's output is "No changes detected" and the table is not modified.

Suggested fix:
Workbench should modify the table to the new fractional seconds number of digits.
[7 Oct 2014 16:35] MySQL Verification Team 
Thank you for the bug report.
[11 Dec 2015 2:12] Philip Olson 
Fixed as of the upcoming MySQL Workbench 6.3.6 release, and here's the changelog entry:

Workbench's Alter Table functionality did not detect changes to fractional
seconds.

Thank you for the bug report.