db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kathey Marsden <kmarsdende...@sbcglobal.net>
Subject bug in soft upgrade mode?
Date Fri, 21 Mar 2008 23:31:27 GMT
In 10.3 I can do this:

ij> create table t0 (i int not null, v varchar(1) not null, constraint  
uq unique(v,i));
0 rows inserted/updated/deleted
ij> alter table t0 alter v set data type varchar(2);
0 rows inserted/updated/deleted
ij>


In 10.4 soft upgrade mode I cannot:
ij> create table t0 (i int not null, v varchar(1) not null, constraint  
uq unique(v,i));
0 rows inserted/updated/deleted
ij> alter table t0 alter v set data type varchar(2);
ERROR 42Z20: Column 'V' cannot be made nullable. It is part of a primary 
key or unique constraint, which cannot have any
 nullable columns.
ij>


I think this is a bug with soft upgrade mode but am not sure.   I think 
setting the type should not change the nullability of the column.  Could 
someone confirm?

Thanks

Kathey







Mime
View raw message