[Info-Ingres] alter table alter column weirdness

[martin.bowes at ctsu.ox.ac.uk]

Hi Guys,

The 'with null not default' is allowed at a table create in Ingres2006, R3, 
II2.0 et al.

Try this...create table a(a integer with null not default)\g

So if the table can be created with this column structure, then we 
should be able to alter to this structure from 'not null not default' 
columns.

Marty

> At 4:49 AM -0700 8/1/07, simonl at unwired.com.au wrote:
> >On Jul 20, 12:16 am, martin.bo... at ctsu.ox.ac.uk wrote:
> >> create table x (a varchar(20) not null not default, b integer not
> >> null not default) with page_size=4096\g alter table x alter column
> >> a varchar(20) with null not default\g
> >
> >Isn't that an erroneous statement?  Not sure if not default and with
> >null have ever been able to co-exist.  If R3 accepted it, that would
> >be a bug in R3.
> 
> I would have to disagree.  If it's NOT accepted, I would consider that
> a bug.  It's perfectly reasonable to have a mandatory nullable column,
> IMO.  It just means that if you want to put a null into the column,
> you have to do it explicitly.
> 
> Karl
> _______________________________________________
> Info-Ingres mailing list
> Info-Ingres at kettleriverconsulting.com
> http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres
>