Message: A new issue has been created in JIRA.
--------------------------------------------------------------------- View the issue: http://issues.apache.org/jira/browse/DERBY-40 Here is an overview of the issue: --------------------------------------------------------------------- Key: DERBY-40 Summary: Cannot set default value for BIGINT Type: Bug Status: Unassigned Priority: Major Project: Derby Versions: 10.0.2.0 Assignee: Reporter: Weiming YIN Created: Mon, 11 Oct 2004 9:22 PM Updated: Mon, 11 Oct 2004 9:22 PM Environment: WINXP+sp2 jdk1.4.2_03, jdk1.3, Filesystem is NTFS 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); --------------------------------------------------------------------- JIRA INFORMATION: This message is automatically generated by JIRA. If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira
