Edson Richter wrote : > >Why could not MaxDB accept NULL values in columns with CHECK >constraint? There are any SQL >standards that dictates this rule (I really never heard about this)? > >Can I fill a request to add this feature? > >Thanks, > >Edson Richter >
MaxDB accepts null values for constraint columns, if the constraint does. Example : create table test (col1 int check col1 > 0) will not accept null values because null > 0 is not true. create table test (col1 int check col1 is null or col1 > 0) will accept null values. Best Regards, Thomas
smime.p7s
Description: S/MIME cryptographic signature
