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 rh...@apache.org on 2017/09/12 00:06:58 UTC
svn commit: r1808072 - /db/derby/docs/trunk/src/ref/rrefsqlj81859.dita
Author: rhillegas
Date: Tue Sep 12 00:06:58 2017
New Revision: 1808072
URL: http://svn.apache.org/viewvc?rev=1808072&view=rev
Log:
DERBY-6959: Doc changes for required SET keyword when changing the cycling behavior of identity columns; commit derby-6959-02-aa-setCycleDocs.diff.
Modified:
db/derby/docs/trunk/src/ref/rrefsqlj81859.dita
Modified: db/derby/docs/trunk/src/ref/rrefsqlj81859.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj81859.dita?rev=1808072&r1=1808071&r2=1808072&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj81859.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj81859.dita Tue Sep 12 00:06:58 2017
@@ -78,7 +78,7 @@ href="rrefconstraintname.dita#rrefconstr
<i>columnName</i> { SET | DROP } NOT NULL |
<i>columnName</i> [ NOT ] NULL |
<i>columnName</i> [ WITH | SET ] DEFAULT <i>defaultValue</i> |
-<i>columnName</i> [ NO ] CYCLE |
+<i>columnName</i> SET [ NO ] CYCLE |
<i>columnName</i> DROP DEFAULT</b> </codeblock></example>
<section><p>In the <i>columnAlteration</i>, SET INCREMENT BY <i>integerConstant</i> specifies
the interval between consecutive values of the identity column. The next value
@@ -313,7 +313,7 @@ ALTER TABLE Employees ALTER COLUMN Salar
ALTER TABLE Employees ALTER COLUMN Salary DROP DEFAULT
<ph>-- Enable CYCLE behavior for the message_id column</ph>
-ALTER TABLE messages ALTER COLUMN message_id CYCLE
+ALTER TABLE messages ALTER COLUMN message_id SET CYCLE
<ph>-- Bulk load a table by temporarily changing a GENERATED ALWAYS identity column
-- into a GENERATED BY default column.