[jira] [Created] (DERBY-6643) ALTER TABLE columnAlteration syntax needs fixing

[Kim Haase (JIRA)]

Kim Haase created DERBY-6643:
--------------------------------

             Summary: 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


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




--
This message was sent by Atlassian JIRA
(v6.2#6252)