Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.ision.net!newsfeed2.easynews.net!ision!newsfeed.freenet.de!213.132.189.2.MISMATCH!multikabel.net!feed20.multikabel.net!sn-xt-ams-06!sn-xt-ams-03!sn-post-ams-01!supernews.com!corp.supernews.com!not-for-mail
From: Hugo Kornelis <hugo@perFact.REMOVETHIS.info.INVALID>
Newsgroups: comp.databases.theory
Subject: Re: Proposal: 6NF
Date: Tue, 10 Oct 2006 01:23:20 +0200
Organization: Posted via Supernews, http://www.supernews.com
Message-ID: <68mli2psv9b7id3gc0jtpr3i70va3438f6@4ax.com>
References: <1159882356.495737.117850@i42g2000cwa.googlegroups.com>   <hwoVg.7861$TV3.6237@newssvr21.news.prodigy.com>   <1160133403.293728.245040@m73g2000cwd.googlegroups.com>   <QxtVg.11$ms1.5@trndny05>   <EEtVg.1274$cz.18103@ursa-nb00s0.nbnet.nb.ca>   <xMxVg.119$ms1.43@trndny05>   <1160164534.301408.114420@c28g2000cwb.googlegroups.com>   <iYMVg.444$P92.281@trndny02> <1160244203.847656.254300@e3g2000cwe.googlegroups.com> <cYYVg.43340$rP1.35905@news-server.bigpond.net.au>
X-Newsreader: Forte Agent 1.91/32.564
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Complaints-To: abuse@supernews.com
Lines: 27
Xref: dp-news.maxwell.syr.edu comp.databases.theory:45644

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