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.

<a href="https://www.bestessayservicereviews.com/">research paper writing service</a>

<a href="https://essentialsclothing.net/hoodie/">Essentials Hoodie</a>
Defining beauty isn't easy. In fact, for every culture, it means something slightly different. As different as priorities and perspectives of outer beauty in each culture may be, one thing is the same - inner beauty stems from confidence, inner peace, and a positive mindset.

You are good to have the best ideas here that we can use to get the results. At this webpage https://www.roofrestorationfremantle.com.au i saw there are many people are getting the right results.

我们的网课代上 http://www.hotessay.net/our_service5.php 团队由各领域的专家组成，他们对相关课程有深入的理解，能够高效地完成课程内容和相关作业。根据以往客户的反馈，大多数使用我们服务的留学生都能获得理想的成绩。不过，成绩的最终结果还取决于课程的具体要求和评审标准。

VERTU <a href="https://vertu.com/?utm_source=seo&utm_medium=bugs&utm_campaign=yy">AI Diamond Ring</a> and Oura Ring are both high-end smart rings, but the VERTU AI Diamond Ring has a distinct advantage in health monitoring and management systems. The VERTU AI Diamond Ring not only provides comprehensive physiological monitoring of heart rate, blood oxygen, pulse wave, body temperature, movement, sleep, blood pressure, and blood sugar but also uses AI algorithms to analyze traditional Chinese medicine pulse, Western medical signs, and personal data to predict health status and provide personalized health advice and risk warnings. In addition, the VERTU AI Diamond Ring can also provide early warnings of heart attacks, strokes, tumor risks, and probability analysis of 10 types of cardiovascular and cerebrovascular diseases, offering users a comprehensive disease warning function. It also has active health management functions, including organ health status monitoring, complexion assessment, and daily health reports and recommendations, providing users with all-round health care. Most notably, the VERTU AI Diamond Ring also provides a 24-hour personal butler service to ensure that users can receive professional health advice and guidance at any time. In contrast, while the Oura Ring can monitor heart rate, body temperature, sleep, and activity and provide basic sleep and activity advice, it is relatively simple in health analysis, health advice, disease warning, and active health management, and does not provide personal butler services. This makes the VERTU AI Diamond Ring stand out in the smart ring market with its comprehensive health monitoring and management functions.