Return-Path: 
 <derby-dev-return-65687-apmail-db-derby-dev-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-derby-dev-archive@www.apache.org
Received: (qmail 73944 invoked from network); 15 Jan 2009 16:25:23 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 15 Jan 2009 16:25:23 -0000
Received: (qmail 86940 invoked by uid 500); 15 Jan 2009 16:25:22 -0000
Delivered-To: apmail-db-derby-dev-archive@db.apache.org
Received: (qmail 86909 invoked by uid 500); 15 Jan 2009 16:25:22 -0000
Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:derby-dev-help@db.apache.org>
List-Unsubscribe: <mailto:derby-dev-unsubscribe@db.apache.org>
List-Post: <mailto:derby-dev@db.apache.org>
List-Id: <derby-dev.db.apache.org>
Reply-To: <derby-dev@db.apache.org>
Delivered-To: mailing list derby-dev@db.apache.org
Received: (qmail 86900 invoked by uid 99); 15 Jan 2009 16:25:22 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 15 Jan 2009 08:25:22 -0800
X-ASF-Spam-Status: No, hits=-2000.0 required=10.0
	tests=ALL_TRUSTED
X-Spam-Check-By: apache.org
Received: from [140.211.11.140] (HELO brutus.apache.org) (140.211.11.140)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 15 Jan 2009 16:25:20 +0000
Received: from brutus (localhost [127.0.0.1])
	by brutus.apache.org (Postfix) with ESMTP id D48EC234C495
	for <derby-dev@db.apache.org>; Thu, 15 Jan 2009 08:24:59 -0800 (PST)
Message-ID: <1230600200.1232036699869.JavaMail.jira@brutus>
Date: Thu, 15 Jan 2009 08:24:59 -0800 (PST)
From: "Dag H. Wanvik (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Commented: (DERBY-4016) Document syntax change for ALTER
 TABLE in Reference Manual
In-Reply-To: <1839494114.1231778402564.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-Virus-Checked: Checked by ClamAV on apache.org


    [ https://issues.apache.org/jira/browse/DERBY-4016?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12664154#action_12664154 ] 

Dag H. Wanvik commented on DERBY-4016:
--------------------------------------

As far as ADD COLUMN, that uses the normal column definition syntax. 

[Section 11.13 in SQL 2003 has the production 

<set column default clause> ::= SET <default clause> 

which is only ever used by <alter column action>, see section 11.12.]

We still do not support the syntax for DROP DEFAULT, but one can specify SET DEFAULT NULL
which has the same semantics as dropping the default. We should probably add this syntax as well. I will
see if I can fit it into DERBY-4013.. Thanks for alerting me.



> Document syntax change for ALTER TABLE in Reference Manual
> ----------------------------------------------------------
>
>                 Key: DERBY-4016
>                 URL: https://issues.apache.org/jira/browse/DERBY-4016
>             Project: Derby
>          Issue Type: Improvement
>          Components: Documentation
>    Affects Versions: 10.5.0.0
>            Reporter: Kim Haase
>            Assignee: Kim Haase
>            Priority: Minor
>
> DERBY-4013 adds support for the standard SET keyword in addition to the optional WITH keyword in ALTER TABLE ALTER [COLUMN] statements. This change should be documented in the Reference Manual.
> Question: [WITH] DEFAULT occurs also in ALTER TABLE ADD COLUMN. Will SET work here as well?

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.