Bug #97411 Column with comments contains '\n' will cause synchronize everytime.
Submitted: 29 Oct 2019 11:34 Modified: 14 Jan 2020 11:35
Reporter: Xiang Long Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:8.0.18 OS:Windows (Microsoft Windows 8.1 Enterprise)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[29 Oct 2019 11:34] Xiang Long
Description:
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\clairech\AppData\Roaming\MySQL\Workbench\log\wb.log]

When we finish the modeling, need to synchronize to the database.
But the column with comments containts '\n' will be updated everytime.

How to repeat:
Add a table
Add a column to it. 
Edit the comment with a ENTER, like 'haha\nhaha'.
Do synchronization, the column need to be updated. [Perfectly]
Do synchronization again, the column need to be updated again. [Not needed]

Suggested fix:
Column with comment contains '\n' should be treated as a normal character.
[14 Jan 2020 11:35] MySQL Verification Team
Hello Xiang Long,

Thank you for the report.
I tried to reproduce your issue on windows 10 with workbench 8.0.18 using dummy model but I am not seeing any issues at my end. To investigate further this issue at our end, may I kindly request you to launch workbench under debug mode (-log-level=debug3) and provide unaltered workbench log file(more details about log are explained here - https://dev.mysql.com/doc/workbench/en/workbench-reporting-bugs.html), Thank you.

Regards,
Ashwini Patil
[11 Dec 2023 13:11] Willian Rocha
For me, this occurs every time for all versions.
My WB is on Windows 11 and the database runs on Oracle Linux and all versions too.