db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From derby-...@db.apache.org
Subject [jira] Closed: (DERBY-40) Cannot set default value for BIGINT
Date Thu, 21 Oct 2004 20:04:14 GMT

   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:

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:

   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

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);

This message is automatically generated by JIRA.

If you think it was sent incorrectly contact one of the administrators:

If you want more information on JIRA, or have a bug to report see:

View raw message