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 4CA0E1108A for ; Mon, 22 Sep 2014 08:26:34 +0000 (UTC) Received: (qmail 21134 invoked by uid 500); 22 Sep 2014 08:26:34 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 21100 invoked by uid 500); 22 Sep 2014 08:26:34 -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 21088 invoked by uid 99); 22 Sep 2014 08:26:34 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 22 Sep 2014 08:26:34 +0000 Date: Mon, 22 Sep 2014 08:26:33 +0000 (UTC) From: "Knut Anders Hatlen (JIRA)" To: derby-dev@db.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (DERBY-3888) ALTER TABLE ... ADD COLUMN cannot add identity columns 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-3888?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Knut Anders Hatlen updated DERBY-3888: -------------------------------------- Attachment: rrefsqlj81859.html d3888-2a-refman.diff Attaching [^d3888-2a-refman.diff] which updates the "ALTER TABLE statement" topic of the reference manual with the new syntax. [^rrefsqlj81859.html] shows what the topic looks like with the changes. After the code changes in this issue, the {{columnDefinition}} syntax is the same for ALTER TABLE and CREATE TABLE. This patch therefore removes the description of {{columnDefinition}} from the "ALTER TABLE statement" topic and points to the definition used by CREATE TABLE instead. > ALTER TABLE ... ADD COLUMN cannot add identity columns > ------------------------------------------------------ > > Key: DERBY-3888 > URL: https://issues.apache.org/jira/browse/DERBY-3888 > Project: Derby > Issue Type: Improvement > Components: SQL > Affects Versions: 10.4.2.0 > Reporter: Knut Anders Hatlen > Assignee: Knut Anders Hatlen > Priority: Minor > Labels: derby_triage10_10 > Attachments: d3888-1a.diff, d3888-2a-refman.diff, reenable-v2.diff, reenable-v3.diff, reenable.diff, rrefsqlj81859.html > > > ALTER TABLE .. ADD COLUMN cannot be used to add an identity column. There is code to handle identity columns, but it is disabled in the parser. See this thread on derby-user: > http://mail-archives.apache.org/mod_mbox/db-derby-user/200708.mbox/%3C46C5DAA9.8080507@sbcglobal.net%3E > The code was disabled for DB2 compatibility. Since DB2 compatibility is not a goal for Derby, we should see if we could re-enable it. -- This message was sent by Atlassian JIRA (v6.3.4#6332)