db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Army <a...@golux.com>
Subject Re: [jira] Created: (DERBY-40) Cannot set default value for BIGINT
Date Tue, 12 Oct 2004 16:00:15 GMT
derby-dev@db.apache.org wrote:

> Message:
>   A new issue has been created in JIRA.

[ snip ]

> Description:
> I create a table in ij, give a default value for BIGINT type will occur error.
> This is my SQL sentence :
>    create table test (id BIGINT default 0);
> the result is 
>    "ERROR 42894: DEFAULT value or IDENTITY attribute value is not valid for column 'ID'."

I have a fix for this problem; will post the patch to dev-list soon (after more thorough testing).
 I think all the 
types should be covered now...


View raw message