[mysqldef] Syntax error when removing table comments using mysqldef

[shahoxo]

Platform

• OS: macOS
• RDBMS: MySQL (TiDB)
• Version: 8.0 (7.5.0)

--export output

CREATE TABLE `users` (
  `id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`)
) COMMENT='something';

Input SQL

CREATE TABLE `users` (
  `id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`)
);

Current output

ALTER TABLE `user_credentials` COMMENT = ;

Expected output

ALTER TABLE `user_credentials` COMMENT = '';

Workaround

Explicitly setting the comment to an empty string in the table definition prevents the syntax error:

CREATE TABLE `users` (
  `id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`)
) COMMENT='';