[Liquibase-user] New Topic: 2.0 Diff auto_increment MySQL Error

[Liquibase Community Forum]

A new topic, '2.0 Diff auto_increment MySQL Error', has been made on a board you are watching.

You can see it at
http://liquibase.org/forum/index.php?topic=858.new#new

The text of the topic is shown below:

Hi,

i have some problems with the diff command. if i compare 2 tables which are almost equal except from the auto_increment attribute, i don't get any changes reported.

Liquibase 2.0.7
MySQL 5.0 and 5.1

Code:
CREATE TABLE `test1`.`auto` (
`id` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`)
)

CREATE TABLE `test2`.`auto` (
`id` int(11) NOT NULL,
PRIMARY KEY (`id`)
)

CREATE TABLE `test1`.`auto2` (
`test` char(1) NOT NULL,
`id` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`test`,`id`)
)

CREATE TABLE `test2`.`auto2` (
`test` char(1) NOT NULL,
`id` int(11) NOT NULL,
PRIMARY KEY (`test`,`id`)
)


Now i have 4 tables, two in each schema. If i try the diff command i get the following result:
Code:
Reference Database: ***@localhost @ jdbc:mysql://localhost:3306/test1
Target Database: ***@localhost @ jdbc:mysql://localhost:3306/test2
Product Name: EQUAL
Product Version: EQUAL
Missing Tables: NONE
Unexpected Tables: NONE
Missing Views: NONE
Unexpected Views: NONE
Changed Views: NONE
Missing Columns: NONE
Unexpected Columns: NONE
Changed Columns: NONE
Missing Foreign Keys: NONE
Unexpected Foreign Keys: NONE
Missing Primary Keys: NONE
Unexpected Primary Keys: NONE
Missing Unique Constraints: NONE
Unexpected Unique Constraints: NONE
Missing Indexes: NONE
Unexpected Indexes: NONE
Missing Sequences: NONE
Unexpected Sequences: NONE


I would have expected 2 Statements to synch the auto_increment attribute.

Unsubscribe to new topics from this board by clicking here: http://liquibase.org/forum/index.php?action=notifyboard;board=1.0

Regards,
The Liquibase Community Forum Team.