Schema Compare Fails To Detect Auto-Increment Missing

[normk]

Using SqlYog Enterprisse 8.17, I ran a Schema Compare on a source and target where one of the tables had auto-increment set on the primary key (id) column and the other did not. The comparison failed to report any differences on this table. I repeated this issue several times to confirm.

Source table:

CREATE TABLE `atest1` (

`id` int(10) NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Target table:

CREATE TABLE `atest1` (

`id` int(10) NOT NULL auto_increment,

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

[nithin]

Hello,

This issue is already fixed in version 8.18. SQlyog version 8.18 release notes tells:

— Schema Sync failed to set the auto-increment flag when syncing a table having this flag to a table not having.

So please verify with latest 8.4RC or 8.32, and let's know the status?

http://www.webyog.com/en/downloads.php

Thanks

Nithin

[Author]

Posts