Incomplete list of existing foreign keys - DatabaseMetaData.crossReferences(...) not used
Description
Informix requires calling the crossReference(…) method from DatabaseMetaData in addition to the getImportedKeys(...) method to correctly identify all existing foreign keys in the database. Since the current list of foreign keys is incomplete, the SchemaUpdate attempts to create the missing one, which results in an error.
Informix requires calling the crossReference(…) method from DatabaseMetaData in addition to the getImportedKeys(...) method to correctly identify all existing foreign keys in the database. Since the current list of foreign keys is incomplete, the SchemaUpdate attempts to create the missing one, which results in an error.
The unit test named
documents this behavior.