[ 
https://issues.apache.org/jira/browse/DERBY-6643?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Kim Haase closed DERBY-6643.
----------------------------


Closing, since changes have appeared in Latest Alpha Manuals.

> 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
>             Fix For: 10.11.0.0
>
>         Attachments: DERBY-6643-2.diff, DERBY-6643.diff, rrefsqlj81859.html, 
> 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)

Reply via email to