Hello
I've created two identical database using the same DDL script, then I ran
diff on them.
I used MySQL version 5.0.27.
Diff found differences on foreign key! Why? What's going wrong?
This is a fragment of the DDL where diff found differences:
PRIMARY KEY (`CODLAB`,`CODACC`,`DATAACC`,`CODESAME`),
KEY `FK_ACCETTAZIONE_ESAMI2` (`CODESAME`),
KEY `FK_ACCETTAZIONE_ESAMI3` (`PROGIMP`,`CODLAB`,`CODACC`,`DATAACC`),
KEY `FK_ACCETTAZIONE_ESAMI4` (`CODLABESE`),
KEY `FK_ACCETTAZIONE_ESAMI5` (`CODMAT`),
CONSTRAINT `FK_ACCETTAZIONE_ESAMI1` FOREIGN KEY (`CODLAB`, `CODACC`,
`DATAACC`) REFERENCES `ACCETTAZIONE` (`CODLAB`, `CODACC`, `DATAACC`) ON
DELETE CASCADE,
CONSTRAINT `FK_ACCETTAZIONE_ESAMI2` FOREIGN KEY (`CODESAME`) REFERENCES
`ESAME` (`CODESAME`),
CONSTRAINT `FK_ACCETTAZIONE_ESAMI3` FOREIGN KEY (`PROGIMP`, `CODLAB`,
`CODACC`, `DATAACC`) REFERENCES `IMPEGNATIVA` (`PROGIMP`, `CODLAB`,
`CODACC`, `DATAACC`),
CONSTRAINT `FK_ACCETTAZIONE_ESAMI4` FOREIGN KEY (`CODLABESE`) REFERENCES
`LABORATORIO` (`CODLAB`),
CONSTRAINT `FK_ACCETTAZIONE_ESAMI5` FOREIGN KEY (`CODMAT`) REFERENCES
`MATERIALI` (`CODMAT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_bin;
And this is Diff output:
Missing Foreign Keys:
FK_ACCETTAZIONE_ESAMI1(ACCETTAZIONE_ESAMI.CODLAB, CODACC, DATAACC
->ACCETTAZIONE.CODLAB, CODACC, DATAACC)
FK_ACCETTAZIONE_ESAMI3(ACCETTAZIONE_ESAMI.PROGIMP, CODLAB, CODACC,
DATAACC ->IMPEGNATIVA.PROGIMP, CODLAB, CODACC, DATAACC)
.....
Unexpected Foreign Keys:
FK_ACCETTAZIONE_ESAMI1(ACCETTAZIONE_ESAMI.CODLAB, CODACC, DATAACC
->ACCETTAZIONE.CODLAB, CODACC, DATAACC)
FK_ACCETTAZIONE_ESAMI3(ACCETTAZIONE_ESAMI.PROGIMP, CODLAB, CODACC,
DATAACC ->IMPEGNATIVA.PROGIMP, CODLAB, CODACC, DATAACC)
Note all foreign key are detected as missing why? I've also tried on a dummy
db with 2 tables and a foreigns key and Diff works fine.
Thanks
Carlo
--
View this message in context:
http://www.nabble.com/Diff-finds-foreign-key-differences-on-two-indentical-MySQL-databases-tp23637060p23637060.html
Sent from the LiquiBase - User mailing list archive at Nabble.com.
------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables
unlimited royalty-free distribution of the report engine
for externally facing server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
Liquibase-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/liquibase-user
