1 Reply Latest reply: Jan 2, 2014 5:26 AM by user10082006 RSS

    Bug: Diff fails for multiple constraints on one column.

    user10082006

      Hi all,

       

      I think, I came across a bug in SQL Developer:

      SQL Developer version: 3.0.04

       

      create table USER_A.foo (val NUMBER not null, CHECK (val IN (1,2,3)));
      

       

      create table USER_B.foo (val NUMBER not null);
      

       

      Comparing these two schemas does not give any difference. However, when not null constraints are removed from both tables, then check constraint difference is correctly reported.