I have defined a table level constraint:
date_id = trunc(date_id)
When I run "Synchronize Data Dictionary with Model", the following DDL is consistently generated:
ALTER TABLE pm_data_mart.dmt_date_dimension DROP CONSTRAINT dmt_date_dimension_ck_1;
ALTER TABLE pm_data_mart.dmt_date_dimension
ADD CONSTRAINT dmt_date_dimension_ck_1 CHECK ( date_id = trunc(date_id) );
If I run the two statements and then repeat "Synchronize Data Dictionary with Model", I would expect no DDL but the same two statements are generated again.
Why is this happening and how can it be prevented?
PS: Version 21.1.0.092 Running against Oracle 19c database.