You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by ka...@apache.org on 2006/10/19 15:01:08 UTC

svn commit: r465615 - /db/derby/docs/trunk/src/ref/rrefsqlj37836.dita

Author: kahatlen
Date: Thu Oct 19 06:01:07 2006
New Revision: 465615

URL: http://svn.apache.org/viewvc?view=rev&rev=465615
Log:
DERBY-1918: INCREMENT of IDENTITY column described as allowing a value
of zero in reference manual

Patch contributed by Dag H. Wanvik.

Modified:
    db/derby/docs/trunk/src/ref/rrefsqlj37836.dita

Modified: db/derby/docs/trunk/src/ref/rrefsqlj37836.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj37836.dita?view=diff&rev=465615&r1=465614&r2=465615
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj37836.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj37836.dita Thu Oct 19 06:01:07 2006
@@ -83,10 +83,10 @@
 </dlentry></dl></p><p>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
+with the key words START WITH and INCREMENT BY. And if you specify a negative
 number for the increment value, <ph conref="refconrefs.dita#prod/productshortname"></ph> <i>decrements</i> the
-value with each insert. If this value is 0, or positive, <ph conref="refconrefs.dita#prod/productshortname"></ph> increments
-the value with each insert.</p><p>The maximum and minimum values allowed in
+value with each insert. If this value is positive, <ph conref="refconrefs.dita#prod/productshortname"></ph> increments
+the value with each insert. A value of 0 raises a statement exception. </p><p>The maximum and minimum values allowed in
 identity columns are determined by the data type of the column. Attempting
 to insert a value outside the range of values supported by the data type raises
 an exception.   <table frame="all"><title>Maximum and Minimum Values for Columns