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

[de...@db.apache.org]

Message:

   The following issue has been closed.

   Resolver: A B
       Date: Thu, 21 Oct 2004 1:02 PM

Fixed with svn commit 55161
---------------------------------------------------------------------
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: Closed
   Priority: Major
 Resolution: FIXED

    Project: Derby
   Fix Fors:
             10.0.2.0
   Versions:
             10.0.2.0

   Assignee: A B
   Reporter: Weiming YIN

    Created: Mon, 11 Oct 2004 9:22 PM
    Updated: Thu, 21 Oct 2004 1:02 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