[
https://issues.apache.org/jira/browse/DERBY-4016?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12665121#action_12665121
]
Knut Anders Hatlen commented on DERBY-4016:
-------------------------------------------
The patch looks fine to me. You're right that we cannot use both WITH and SET.
I'm not sure if DROP DEFAULT and SET DEFAULT NULL have the exact same semantics
(DROP DEFAULT is supposed to fail if there is no default, I think) but the
current wording, which just says that SET DEFAULT NULL is an alternative,
should be OK.
> 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
> Attachments: DERBY-4016.diff, DERBY-4016.diff, rrefsqlj81859.html,
> rrefsqlj81859.html
>
>
> 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.
