[ http://issues.apache.org/jira/browse/DERBY-1918?page=all ]
Knut Anders Hatlen resolved DERBY-1918. --------------------------------------- Resolution: Fixed Derby Info: (was: [Patch Available]) Committed revision 465615. > 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.1.3.1, 10.2.2.0 > Reporter: Dag H. Wanvik > Assigned To: Dag H. Wanvik > Priority: Trivial > Fix For: 10.3.0.0 > > 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 > 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