[jira] Updated: (DERBY-1918) INCREMENT of IDENTITY column described as allowing a value of zero in reference manual

["Dag H. Wanvik (JIRA)" <de...@db.apache.org>]

     [ http://issues.apache.org/jira/browse/DERBY-1918?page=all ]

Dag H. Wanvik updated DERBY-1918:
---------------------------------

        Fix Version/s: 10.3.0.0
    Affects Version/s: 10.2.1.6
                       10.2.2.0
                       10.3.0.0

> 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: 10.2.1.6, 10.3.0.0, 10.2.2.0
>            Reporter: Dag H. Wanvik
>            Priority: Trivial
>             Fix For: 10.3.0.0
>
>
> 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
> error 42Z21 (LANG_AI_INVALID_INCREMENT):
> 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