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: Verified Impact on me:
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
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.