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: a...@localhost @ jdbc:mysql://localhost:3306/test1
Target Database: a...@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.
------------------------------------------------------------------------------
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and,
should the need arise, upgrade to a full multi-node Oracle RAC database
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________
Liquibase-user mailing list
Liquibase-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/liquibase-user
