[
https://issues.apache.org/jira/browse/DERBY-3959?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12656778#action_12656778
]
Kim Haase commented on DERBY-3959:
----------------------------------
The GeneratedColumns.html spec shows the same column-definition syntax for both
CREATE TABLE and ALTER TABLE:
column-definition ::= Simple-column-Name [ DataType ]
[ Column-level-constraint ]*
[ [ WITH ] DEFAULT DefaultConstantExpression
| generated-column-spec
| generation-clause
]
[ Column-level-constraint ]*
Currently, though, the syntax described for CREATE TABLE in
http://db.apache.org/derby/docs/dev/ref/rrefsqlj30540.html#rrefsqlj30540 is not
quite the same as the syntax described for ALTER TABLE in
http://db.apache.org/derby/docs/dev/ref/rrefsqlj81859.html. The syntax for
CREATE TABLE is the same as what's in the Generated Columns spec except for the
changes. But the syntax for ALTER TABLE looks different:
Simple-column-Name DataType
[ Column-level-constraint ]*
[ [ WITH ] DEFAULT DefaultConstantExpression ]
It lacks both the generated-column-spec and the additional
Column-level-constraint at the end. Should it be changed to be the same?
> Reference Manual needs information on generated columns
> -------------------------------------------------------
>
> Key: DERBY-3959
> URL: https://issues.apache.org/jira/browse/DERBY-3959
> Project: Derby
> Issue Type: New Feature
> Components: Documentation
> Affects Versions: 10.5.0.0
> Reporter: Kim Haase
> Assignee: Kim Haase
>
> The Generated Columns specification attached to DERBY-481 describes changes
> that need to be made to the Derby Reference Manual to document this new
> feature. This issue covers the implementation of these changes.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
