Forum Stats

  • 3,768,568 Users
  • 2,252,811 Discussions
  • 7,874,624 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