MySQL Bugs: #94485: comment has a comment truncated even on a very short comment

Bug #94485	comment has a comment truncated even on a very short comment
Submitted:	27 Feb 2019 4:14	Modified:	16 May 2020 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

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.

Thank you for the bug report. Please provide the model file test case (private if you wish). Thanks in advance.

sample model

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

Thank you for the feedback.

Thanks for the response, just tell me if there is anything you need.

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.

Hi Susan Lynch, I think the purpose of your comment is just to put a link of your site for spamming.