db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Duncan Groenewald <duncangroenew...@xtra.co.nz>
Subject Re: SQL Parser failing on NULL column contraint
Date Wed, 30 Aug 2006 12:42:18 GMT
Can someone confirm that the following statement will fail because Derby 
can't handle a NULL constraint

create table SampleTable(
    code int   NOT NULL,
    description varchar(32) NOT NULL,
    address varchar(256)  NULL,
    phone varchar(32) NULL
    )

whereas this will work fine

create table SampleTable(
    code int   NOT NULL,
    description varchar(32) NOT NULL,
    address varchar(256),
    phone varchar(32)
    )

Any chance someone can explain how I could modify the parser (or 
whatever) to be able to handle the NULL constraint ?

Thanks
Duncan


Mime
View raw message