Schema Sync Syntax Error

[ricrat51]

Using SQLyog Ultimate MySQL GUI v9.20

When using Schema Synchronization Tool

A syntax error occurs when a table has only the comment changed between two databases

Generated SQL

ALTER TABLE `tablename`, COMMENT='comment here';

FYI

[peterlaursen]

Please confirm:

1) both source and target has a comment?

2) the comments we are talking about is a table-level (and not a column-level) comment?

[peterlaursen]

On latest internal build I get

— source

CREATE TABLE `t1` (

`id` INT(11) DEFAULT NULL

) ENGINE=INNODB DEFAULT CHARSET=utf8 COMMENT='this';

— target

CREATE TABLE `t1` (

`id` INT(11) DEFAULT NULL

) ENGINE=INNODB DEFAULT CHARSET=utf8 COMMENT='that';

— ALTER script

ALTER TABLE `t1` COMMENT='this'; — no comma

So either this requires a specific table to reproduce or it has been fixed in between. I will discuss with team tomorrow.

[peterlaursen]

I cannot reproduce with version 9.2 either.

Please post CREATE TABLE scripts for two tables where this is reproducible.

[Author]

Posts