You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-dev@db.apache.org by "Kim Haase (JIRA)" <ji...@apache.org> on 2014/07/01 14:53:24 UTC

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

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)