db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From derby-...@db.apache.org
Subject [jira] Created: (DERBY-40) Cannot set default value for BIGINT
Date Tue, 12 Oct 2004 04:23:51 GMT
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


Mime
View raw message