db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendle...@amberpoint.com>
Subject Re: problem with ALTER COLUMN DEFAULT on VARCHAR column
Date Fri, 23 Feb 2007 15:34:57 GMT
> If however the column contains data then the SELECT MAX... returns a 
> string value.

Hi Tim,

I think you've pinpointed this one, and I think it's definitely a bug.

Can you file it in Jira so we can get it fixed? Here's a simple script:

-bash-2.05b$ java org.apache.derby.tools.ij
ij version 10.3
ij> connect 'jdbc:derby:brydb';
ij> create table t (a varchar(10));
0 rows inserted/updated/deleted
ij> alter table t alter column a default 'my val';
0 rows inserted/updated/deleted
ij> insert into t (a) values ('hi');
1 row inserted/updated/deleted
ij> alter table t alter column a default 'another val';
ERROR 22018: Invalid character string format for type long.

thanks,

bryan


Mime
View raw message