[Info-Ingres] alter table alter column weirdness

simonl at unwired.com.au simonl at unwired.com.au
Wed Aug 1 06:49:01 CDT 2007


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.



More information about the Info-Ingres mailing list