Re: Proposal: 6NF

On Sun, 08 Oct 2006 01:59:36 GMT, Frank Hamersley wrote:

(snip)
>Should I try it on Sybase ASE 12.5?
>
>> create table table1(field1 int, field2 varchar(1))
>> go
>> insert table1
>> select 1, 'A'
>> insert table1
>> select 2, 'B'
>> insert table1
>> select 3, 'C'
>> insert table1
>> select NULL, 'B'
>
>Hmmm - the last statement fails...as it should!

Hi Frank,

No, it should not. None of the columns in the "table" is constrained to disallow NULLs, so the insert shoould be accepted.

Sybase disallowing NULL in a column unless stated otherwise, violates the ANSI standards.

Best, Hugo Received on Tue Oct 10 2006 - 01:23:20 CEST