[
https://issues.apache.org/jira/browse/DERBY-6643?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kim Haase updated DERBY-6643:
-----------------------------
Description:
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.
was:
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 )."
> 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)
