[DERBY-40] Cannot set default value for BIGINT

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.0.2.0
• Fix Version/s: 10.0.2.0
• Component/s: SQL
• Environment: WINXP+sp2 jdk1.4.2_03, jdk1.3, Filesystem is NTFS
• Assignee: A B
• Reporter: Weiming YIN
• Created: 12/Oct/04 04:22
• Updated: 12/Jul/06 00:08
• Resolved: 21/Oct/04 20:02

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'."

but the following sql works well.
create table test (id int default 0);