db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mamta Satoor <msat...@gmail.com>
Subject Re: DB2 mode vs. Cloudscape mode
Date Thu, 03 Mar 2005 20:54:25 GMT
On Thu, 3 Mar 2005 21:33:21 +0100, Bernt M. Johnsen <bernt@sun.com> wrote:
> Hi all!
> 
> In the Derby source, I find several comments referring to "DB2 mode"
> and "Cloudscape mode". I can't, however, find any code related to a
> distinction between these two modes. Are these comments "leftovers"
> from the pre-Derby period of the code, or have I missed something?
> 
> The reason I wonder is the error message
> 
> ij> create table tab (i integer primary key);
> ERROR 42831: 'I' cannot be a column of a primary key or unique key because it can contain
null values.
> 
> and comments in the code like
> 
> > * Set all columns in that appear in a primary/unique key constraint in a create
> > * table statement to NOT NULL in Cloudscape mode and raises an error in DB2 mode.
> 
> and
> 
> >  /* For primary/unique/unique keys, verify that the constraint's column
> >   * list contains valid columns and does not contain any duplicates
> >   * (Also, all columns in a primary key will be set to non-null,
> >       but only in Cloudscape mode. SQL and DB2 require explict NOT NULL.
> 
> --
> Bernt Marius Johnsen, HA Data Management, Sun Microsystems, Norway
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> NOTICE: This signature is neither personal, religious, literary,
> ethnic, racial, offensive nor humorous.
> 

Hi Brent,

Those are left over comments that need to be cleaned up. Derby does
not have 2 modes.

Mamta

Mime
View raw message