Synchronize Domain constraints

mmagan-Oracle

I have a domain defined with a check constraint, defined as a Generic Constraint:

%COLUMN% = upper(%COLUMN%)

I have a table with two columns based on this domain.

When I run "Synchronize Data Dictionary with Model", the following DDL is consistently generated:

ALTER TABLE pm_data_mart.stg_worklogs DROP CONSTRAINT stg_worklogs_ck_parentkey;

ALTER TABLE pm_data_mart.stg_worklogs

   ADD CONSTRAINT stg_worklogs_ck_parentkey CHECK ( parentkey = upper(parentkey) );

I.e. one of the two constraints is recreated. Is this a bug?

(Version 21.1.0.092 running against 19c database)

jflack

Just as with your other recent question, your SDDM version should be mentioned in your question.

mmagan-Oracle

Thanks John. Updated version in post above.