Return-Path: X-Original-To: apmail-db-derby-dev-archive@www.apache.org Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id EC4B010F4A for ; Tue, 1 Jul 2014 13:43:24 +0000 (UTC) Received: (qmail 56701 invoked by uid 500); 1 Jul 2014 13:43:24 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 56667 invoked by uid 500); 1 Jul 2014 13:43:24 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 56647 invoked by uid 99); 1 Jul 2014 13:43:24 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 01 Jul 2014 13:43:24 +0000 Date: Tue, 1 Jul 2014 13:43:24 +0000 (UTC) From: "Kim Haase (JIRA)" To: derby-dev@db.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (DERBY-6643) ALTER TABLE columnAlteration syntax needs fixing MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/DERBY-6643?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kim Haase updated DERBY-6643: ----------------------------- Attachment: rrefsqlj81859.html DERBY-6643.diff Attaching DERBY-6643.diff and rrefsqlj81859.html, with changes to the ALTER TABLE topic: M src/ref/rrefsqlj81859.dita Please let me know if other changes are needed. Thanks! > ALTER TABLE columnAlteration syntax needs fixing > ------------------------------------------------ > > Key: DERBY-6643 > URL: https://issues.apache.org/jira/browse/DERBY-6643 > Project: Derby > Issue Type: Bug > Components: Documentation > Affects Versions: 10.11.0.0 > Reporter: Kim Haase > Assignee: Kim Haase > Priority: Minor > Attachments: DERBY-6643.diff, rrefsqlj81859.html > > > Knut Anders Hatlen points out in a comment on DERBY-6609 that the columnAlteration syntax in the ALTER TABLE statement topic is not quite correct. It is possible to set the data type to BLOB or CLOB, in addition to VARCHAR and VARCHAR FOR BIT DATA. > Also, for VARCHAR FOR BIT DATA, he notes, "the length argument is on the wrong spot. It should be columnName SET DATA TYPE VARCHAR ( integer ) FOR BIT DATA, rather than columnName SET DATA TYPE VARCHAR FOR BIT DATA( integer )." -- This message was sent by Atlassian JIRA (v6.2#6252)