[ 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)