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
• Status: Verified
• Category: MySQL Workbench: Modeling
• Severity: S2 (Serious)
• Version: 8.0.22
• OS: Windows (10 v2004)
• 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