Return-Path:
X-Original-To: apmail-db-derby-commits-archive@www.apache.org
Delivered-To: apmail-db-derby-commits-archive@www.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
by minotaur.apache.org (Postfix) with SMTP id DC65511E3A
for ;
Wed, 2 Jul 2014 13:09:36 +0000 (UTC)
Received: (qmail 45335 invoked by uid 500); 2 Jul 2014 13:09:36 -0000
Delivered-To: apmail-db-derby-commits-archive@db.apache.org
Received: (qmail 45309 invoked by uid 500); 2 Jul 2014 13:09:36 -0000
Mailing-List: contact derby-commits-help@db.apache.org; run by ezmlm
Precedence: bulk
list-help:
list-unsubscribe:
List-Post:
Reply-To: "Derby Development"
List-Id:
Delivered-To: mailing list derby-commits@db.apache.org
Received: (qmail 45296 invoked by uid 99); 2 Jul 2014 13:09:36 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 02 Jul 2014 13:09:36 +0000
X-ASF-Spam-Status: No, hits=-2000.0 required=5.0
tests=ALL_TRUSTED
X-Spam-Check-By: apache.org
Received: from [140.211.11.4] (HELO eris.apache.org) (140.211.11.4)
by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 02 Jul 2014 13:09:38 +0000
Received: from eris.apache.org (localhost [127.0.0.1])
by eris.apache.org (Postfix) with ESMTP id 29F7123888D2;
Wed, 2 Jul 2014 13:09:13 +0000 (UTC)
Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Subject: svn commit: r1607358 -
/db/derby/docs/trunk/src/ref/rrefsqlj81859.dita
Date: Wed, 02 Jul 2014 13:09:13 -0000
To: derby-commits@db.apache.org
From: chaase3@apache.org
X-Mailer: svnmailer-1.0.9
Message-Id: <20140702130913.29F7123888D2@eris.apache.org>
X-Virus-Checked: Checked by ClamAV on apache.org
Author: chaase3
Date: Wed Jul 2 13:09:12 2014
New Revision: 1607358
URL: http://svn.apache.org/r1607358
Log:
DERBY-6643 ALTER TABLE columnAlteration syntax needs fixing
Modified a Reference Manual topic.
Patch: DERBY-6643.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=1607358&r1=1607357&r2=1607358&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj81859.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj81859.dita Wed Jul 2 13:09:12 2014
@@ -37,7 +37,8 @@ tablesTablesAdd a constraint to a table
Drop a column from a table
Drop an existing constraint from a table
-Increase the width of a VARCHAR or VARCHAR FOR BIT DATA column
+Increase the width of a BLOB, CLOB, VARCHAR, or VARCHAR FOR BIT DATA
+column
Override row-level locking for the table (or drop the override)
Change the increment value and start value of the identity column
Change the nullability constraint for a column
@@ -80,8 +81,10 @@ assignable to DataType.
For details on defaultConstantExpression, see
Column default.
columnAlteration
-columnName SET DATA TYPE VARCHAR( integer ) |
-columnName SET DATA TYPE VARCHAR FOR BIT DATA( integer ) |
+columnName SET DATA TYPE BLOB( integer ) |
+columnName SET DATA TYPE CLOB( integer ) |
+columnName SET DATA TYPE VARCHAR( integer ) |
+columnName SET DATA TYPE VARCHAR( integer ) FOR BIT DATA |
columnName SET INCREMENT BY integerConstant |
columnName RESTART WITH integerConstant |
columnName [ NOT ] NULL |