MySQL Bugs: #103258: Synchronize Model always says a table has differences, if a column has a comment

Bug #103258	Synchronize Model always says a table has differences, if a column has a comment
Submitted:	8 Apr 2021 19:31	Modified:	15 Apr 2021 12:47
Reporter:	James Steven	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	8.0.19	OS:	Windows
Assigned to:		CPU Architecture:	Any

Description:
When synchronizing a model, any table with a column containing a comment will show up as having a difference, even if nothing has been changed.

How to repeat:
Create a table with a column containing a comment. Synchronize model. Synchronize model again without making any changes. It will say there's a difference in the column with the comment.

Suggested fix:
Don't know why the comments causes this.

Screenshot showing the problem

Attachment: mysql.png (image/png, text), 31.86 KiB.

I added a screenshot showing the problem. Even if no changes have been made to any tables, all tables with a column with comment will show up like shown in the screenshot.

I've had this problem in Workbench for many years, e.g. not something recently introduced.

Hello James Steven,

Thank you for the bug report.
I tried to reproduce your issue on windows 10 with workbench 8.0.23 but I am not seeing any issues at my end. 
Please try version 8.0.23. Thanks.

Regards,
Ashwini Patil

I upgraded to latest version, but problem is still there.

I noticed that it also applies to all views. E.g, even if nothing has been changed, it will claim all the views are different and want to recreate them.

I attached a file showing the result of what it want to execute, even though nothing at all was changed. (I completed a synchronize, and immediately when it finished, I went to synchronize again, and this was the result).

Maybe it's something to do with charset/locales? It just says default char/collation, so not sure what that is.

The project file is very old, could be related to that also....

8.0.23 test results

Attachment: 103258_test_results.png (image/png, text), 72.53 KiB.

Hello James Steven,

Thank you for the feedback.
I still cannot reproduce this at my end. Please see the attached screenshot.

Regards,
Ashwini Patil

I have attached an export of my database that can be imported using "reverse enginere script file" - should be able to recreate using that? At least I was able to recreate it like that.

It's very strange... It seems it's not happening on ALL table with a comment, only some.

In one instance, it was caused by the comment having a =, - or newline. After I removed all that it no longer claimed it was changed.

However, in another table, the column comment is simply "Minutter" and it still treats that table as changed every time.

All my views are always treated as changed every time, even though there's no comment.

Hello James Steven,

Thank you for the feedback.
Imho this is duplicate/related to Bug #90772, please see Bug #90772.

Regards,
Ashwini Patil