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.0
MySQL 5.0 and 5.1
-
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:
- Reference Database: ab@localhost @ jdbc:mysql://localhost:3306/test1
Target Database: ab@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.