Bug #94485 comment has a comment truncated even on a very short comment
Submitted: 27 Feb 2019 4:14 Modified: 16 May 11:48
Reporter: Gilbert Consellado Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S3 (Non-critical)
Version:8.0.15 OS:Fedora (fedora 29 x86_64)
Assigned to: CPU Architecture:Any

[27 Feb 2019 4:14] Gilbert Consellado
Description:
The generated sql script from model synchronization produce invalid script if one of the columns has comments.

Worbench version: 8.0.15 build 14271522 CE (64 bits)

sample generated script.

-- MySQL Workbench Synchronization
-- Generated: 2019-02-27 12:10
-- Model: New Model
-- Version: 1.0
-- Project: Name of the project
-- Author: **********

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';

ALTER TABLE `amc`.`tbl_monthly_interest` 
ADD COLUMN `claimed` TINYINT(1) NOT NULL DEFAULT '0' COMMENT  /* comment truncated */ /*flag if the interest is claimed*/ AFTER `amount`;

CREATE TABLE IF NOT EXISTS `amc`.`tbl_test` (
  `id` INT(10) UNSIGNED NOT NULL,
  `test` VARCHAR(255) NOT NULL COMMENT  /* comment truncated */ /*test comment*/,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci;

SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;

How to repeat:
Create a model with tables that has comment, then synchronize the model using the "Synchronize with Any Source" then the generated script is invalid and will produce error if executed.
[27 Feb 2019 8:10] MySQL Verification Team
Thank you for the bug report. Please provide the model file test case (private if you wish). Thanks in advance.
[27 Feb 2019 11:18] Gilbert Consellado
sample model

Attachment: model.mwb (application/vnd.mysql-workbench-model, text), 5.34 KiB.

[27 Feb 2019 11:32] MySQL Verification Team
Thank you for the feedback.
[27 Feb 2019 11:36] Gilbert Consellado
Thanks for the response, just tell me if there is anything you need.
[16 May 8:18] Susan Lynch
This kind of bug is removed and identified for the removal from the ranks. All the patterns of the bug and https://www.researchwritingking.com/review-of-samedayessay-com/ for the top of the class for the turns. The chunk is phased for the flow of the offered announcements. The bug is a ridiculous program mistake for the users.
[16 May 11:48] Gilbert Consellado
Hi Susan Lynch, I think the purpose of your comment is just to put a link of your site for spamming.