Bug #94485 comment has a comment truncated even on a very short comment

• Submitted: 27 Feb 4:14
• Modified: 27 Feb 11:36
• Reporter: Gilbert Consellado
• Status: Verified
• Category: MySQL Workbench: Modeling
• Severity: S3 (Non-critical)
• Version: 8.0.15
• OS: Fedora (fedora 29 x86_64)
• CPU Architecture: Any

[27 Feb 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 8:10] Miguel Solorzano

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

[27 Feb 11:18] Gilbert Consellado

sample model

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

[27 Feb 11:32] Miguel Solorzano

Thank you for the feedback.

[27 Feb 11:36] Gilbert Consellado

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