MySQL Bugs: #72904: Table comments quietly truncated after newlines

Bug #72904	Table comments quietly truncated after newlines
Submitted:	6 Jun 2014 19:43	Modified:	28 Aug 2014 1:00
Reporter:	Technical Support	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S3 (Non-critical)
Version:	6.1.6	OS:	Windows
Assigned to:		CPU Architecture:	Any

Description:
When a newline is entered in a table comment, any following content is discarded when applying. For example, I tried entering the following comment:

Passagers
Remplacée par ins_pax avant 2013

The SQL query generated was:

ALTER TABLE `cohtaxion2`.`ins_passager` 

COMMENT = 'Passagers' /* comment truncated */ /*Remplacée par ins_pax avant 2013*/ ;

I can however enter an equally long comment by replacing the newline with a period:

Passagers. Remplacée par ins_pax avant 2013

There is no proper warning that the comment will be partly discarded, although an inspection of the query will reveal that. This happens on Windows 8.

How to repeat:
Enter a comment with content after a newline.
Apply

Thank you for the bug report. I guess that isn't Workbench Administration are you
using SQL Editor or Modeling?. Thanks.

I am not sure what Workbench Administration and SQL Editor are, but I am not using Modeling, I was changing the schema for real.
Note that manual chapters are misnumbered past the fourth (there's an offset of 1).

Thank you for the feedback.

Fixed as of the upcoming MySQL Workbench 6.2.2 release, and here's the changelog entry:

New lines inside an SQL statement comment would truncate the comment at
the new line.

Thank you for the bug report.