Bug #101967 "Synchronize with Any Source" produces malformed COMMENT statements
Submitted: 10 Dec 2020 23:14 Modified: 11 Dec 2020 8:34
Reporter: Jan Hieronymus Email Updates:
Status: Won't Fix Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S2 (Serious)
Version:8.0.22 OS:Windows (10 v2004)
Assigned to: CPU Architecture:x86

[10 Dec 2020 23:14] Jan Hieronymus
Description:
Using Database -> Synchronize with Any Source , all comments on tables and columns will be exported as "COMMENT = /* comment truncated */ /*<actual comment in full length>*/", which is syntactically invalid and therefore breaks this features.

How to repeat:
Synchronize any table with a new comment on the table or a column using Database -> Synchronize with Any Source.

Suggested fix:
remove /* truncated comment */ and replace the comment markers (/**/) by single-quotes.
[11 Dec 2020 8:34] MySQL Verification Team
Hello Jan Hieronymus,

Thank you for the report and feedback.

regards,
Umesh
[14 Sep 18:05] Omer Barnir
Posted by developer:

This issue applies to the legacy MySQL Workbench 8.x implementation that is no longer supported or maintained.
MySQL Workbench 26.7 is a complete rewrite using a new technology stack and does not use the affected legacy implementation.
Therefore, this issue is not applicable to the current MySQL Workbench product and as such is closed.