db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dag H. Wanvik (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-4016) Document syntax change for ALTER TABLE in Reference Manual
Date Thu, 15 Jan 2009 16:24:59 GMT

    [ 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.


Mime
View raw message