[ 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
