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:
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

[20 Dec 2017 11:38] Andrew Cornforth
'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:
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.
[20 Dec 2017 13:28] Chiranjeevi Battula
Hello Andrew Cornforth,

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

[15 Feb 2018 15:24] Andrew Cornforth
fix typo
[25 Apr 2018 19:31] Christine Cole
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

Thank you for the bug report.