Re: [jira] Created: (DERBY-40) Cannot set default value for BIGINT

derby-dev-PvNy6fhA98DNLxjTenLetw@xxxxxxxxxxxxxxxx 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...

Army