db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (JIRA)" <derby-...@db.apache.org>
Subject [jira] Updated: (DERBY-40) Cannot set default value for BIGINT
Date Tue, 11 Jul 2006 17:09:31 GMT
     [ http://issues.apache.org/jira/browse/DERBY-40?page=all ]

Rick Hillegas updated DERBY-40:
-------------------------------

    Component: SQL

Assigning to SQL component.

> Cannot set default value for BIGINT
> -----------------------------------
>
>          Key: DERBY-40
>          URL: http://issues.apache.org/jira/browse/DERBY-40
>      Project: Derby
>         Type: Bug

>   Components: SQL
>     Versions: 10.0.2.0
>  Environment: WINXP+sp2 jdk1.4.2_03, jdk1.3,  Filesystem is NTFS
>     Reporter: Weiming YIN
>     Assignee: A B
>      Fix For: 10.0.2.0

>
> 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:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


Mime
View raw message