Hello SQL Developer Data Modeler-Team,
I upgraded to 4.0.3.853 from 4.0.2.840 yesterday and noticed problems with the generation of check constraints:
I used every version of Data Modeler so far with this model (created April 2013), so most likely starting with 3.1.4.710.
I have a relational model and one 11g physical model. Physical model is always open when working with the model.
It seems that both Export -> DDL File and Relational-Model -> Table-Right-Click-> DDL preview manage to create ALTER TABLE ... ADD CONSTRAINT CK_ ... for Table-level Check Constraints.
Since a few month I try to have Check Constraints accessing many columns here and Check Constraints accessing only one column in the column properties under
"Table properties" -> Columns -> Column-Doubleclick -> Default and Constraint -> Constraint -> Generic Constraint.
For these constraints, the generated DDL is:
-- WARNING: Column t_sys_process.enabled has no check constraint defined for this database type
I'm pretty sure that this is a bug. Could you please test / confirm?
Thank you & Best regards,
Blama