MySQL Bugs: #88985: Updating column collation on a Table doesn't register as a change to be applied

Bug #88985	Updating column collation on a Table doesn't register as a change to be applied
Submitted:	20 Dec 2017 11:38	Modified:	25 Apr 2018 19:31
Reporter:	Andrew Cornforth	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: Administration	Severity:	S3 (Non-critical)
Version:	6.3.10	OS:	Linux (LinuxMint 18.2 x86_64)
Assigned to:		CPU Architecture:	Any
Tags:	WBBugReporter

Description:
'Apply' button on 'Alter Table' tab will only apply changes if it detects them.
It seems that changing the collation of a column doesn't get picked up by this change detection mechanism after

How to repeat:
after changing the collation of an entire table, right click a table in schema pane and select 'alter table', change the collation of a column under 'column details' to the same collation you set made the table default and try to apply.
Dialog appears informing that no change were detected to apply.

Suggested fix:
workaround:
add a comment to the column, this triggers the 'apply' to work, the comment can then be removed afterward.

Real fix:
detect when column collation changes, even if it is to the same collation as the table's default, and apply changes when applicable.

Hello Andrew Cornforth,

Thank you for the bug report.
Verified this behavior on MySQL Workbench in 6.3.10 version.

Thanks,
Chiranjeevi.

fix typo

Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 8.0.12 release, and here's the changelog entry:

Column collation changes when made using the table editor could not be
applied. Instead, a message indicating that no changes were detected was
displayed.

Thank you for the bug report.