db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kim Haase (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DERBY-6643) ALTER TABLE columnAlteration syntax needs fixing
Date Tue, 01 Jul 2014 12:53:24 GMT
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)

Mime
View raw message