Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Schema Compare Fails To Detect Auto-Increment Missing

forums forums SQLyog SQLyog: Bugs / Feature Requests Schema Compare Fails To Detect Auto-Increment Missing

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • #11949
      normk
      Member

      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;

    • #30778
      nithin
      Member

      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

Viewing 1 reply thread
  • You must be logged in to reply to this topic.