[
https://issues.apache.org/jira/browse/DERBY-6643?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14051234#comment-14051234
]
Knut Anders Hatlen commented on DERBY-6643:
-------------------------------------------
The work on DERBY-6644 is done, so the new syntax (\{SET | DROP \} NOT NULL)
could be added to columnAlteration as an alternative to the existing \[ NOT \]
NULL syntax.
> ALTER TABLE columnAlteration syntax needs fixing
> ------------------------------------------------
>
> Key: DERBY-6643
> URL: https://issues.apache.org/jira/browse/DERBY-6643
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.11.0.0
> Reporter: Kim Haase
> Assignee: Kim Haase
> Priority: Minor
> Attachments: DERBY-6643.diff, rrefsqlj81859.html
>
>
> Knut Anders Hatlen points out in a comment on DERBY-6609 that the
> columnAlteration syntax in the ALTER TABLE statement topic is not quite
> correct. It is possible to set the data type to BLOB or CLOB, in addition to
> VARCHAR and VARCHAR FOR BIT DATA.
> Also, for VARCHAR FOR BIT DATA, he notes, "the length argument is on the
> wrong spot. It should be columnName SET DATA TYPE VARCHAR ( integer ) FOR BIT
> DATA, rather than columnName SET DATA TYPE VARCHAR FOR BIT DATA( integer )."
> DERBY-6644 also requires a change to the columnAlteration syntax.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
