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)