Forum Stats

  • 3,781,248 Users
  • 2,254,496 Discussions
  • 7,879,623 Comments

Discussions

Synchronize Domain constraints

mmagan-Oracle
mmagan-Oracle Member Posts: 30 Employee

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)

Answers