db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dag H. Wanvik (JIRA)" <derby-...@db.apache.org>
Subject [jira] Updated: (DERBY-1918) INCREMENT of IDENTITY column described as allowing a value of zero in reference manual
Date Wed, 04 Oct 2006 15:53:21 GMT
     [ http://issues.apache.org/jira/browse/DERBY-1918?page=all ]

Dag H. Wanvik updated DERBY-1918:

    Affects Version/s:

> INCREMENT of IDENTITY column described as allowing a value of zero in reference manual
> --------------------------------------------------------------------------------------
>                 Key: DERBY-1918
>                 URL: http://issues.apache.org/jira/browse/DERBY-1918
>             Project: Derby
>          Issue Type: Bug
>          Components: Documentation
>    Affects Versions:,,,
>            Reporter: Dag H. Wanvik
>            Priority: Trivial
>             Fix For:
>         Attachments: derby1918.diff, derby1918.stat
> In the description of how INCREMENT work with IDENTITY columns, th
> reference manual is out of step with the implementation in the following respect
> (quote from http://db.apache.org/derby/docs/10.2/ref/rrefsqlj37836.html):
> > By default, the initial value of an identity column is 1, and the
> > amount of the increment is 1. You can specify non-default values for
> > both the initial value and the interval amount when you define the
> > column with the key words STARTS WITH and INCREMENT BY. And if you
> > specify a negative number for the increment value, Derby decrements
> > the value with each insert. If this value is 0, or positive, Derby
>                                                     ******************
> > increments the value with each insert.
> In fact, the implementation does not allow a value of zero, but gives
> ij> create table f (i int generated by default as identity (start with 1, increment
by 0), j int);
> ERROR 42Z21: Invalid increment specified for identity for column 'I'. Increment cannot
be zero.  

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


View raw message