Hi,
I have a DB2 database that I'm trying to diff against a liquibase changelog
XML file (by loading the XML file into an HSQL in-memory database first) and
the only difference between them is that one column in DB2 has a
nullable=false constraint and the same column in the changelog has:
<constraints nullable="false" unique="true"
uniqueConstraintName="UNIQUE01"/>
When I run my diff I get the following difference in the report output:
Missing Indexes:
SYS_IDX_UNIQUE01_10064 on NOT_NULL_TBL(CHAR_1)
but the strange thing is that sometimes when I run the diff the name is:
SYS_IDX_UNIQUE01_10063 and other times it's: SYS_IDX_UNIQUE01_10064.
Does anyone know where the '_10064' part of the name is coming from, and why
it's not the same every time I run the diff?
Also, why is it under the Missing Indexes section instead of the Missing
Unique Constraints section?
--
View this message in context:
http://old.nabble.com/How-are-unique-constraint-names-created--tp28488955p28488955.html
Sent from the LiquiBase - User mailing list archive at Nabble.com.
------------------------------------------------------------------------------
_______________________________________________
Liquibase-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/liquibase-user
