db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF subversion and git services (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-6643) ALTER TABLE columnAlteration syntax needs fixing
Date Thu, 03 Jul 2014 18:18:34 GMT

    [ https://issues.apache.org/jira/browse/DERBY-6643?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14051779#comment-14051779
] 

ASF subversion and git services commented on DERBY-6643:
--------------------------------------------------------

Commit 1607706 from [~chaase3] in branch 'docs/trunk'
[ https://svn.apache.org/r1607706 ]

DERBY-6643  ALTER TABLE columnAlteration syntax needs fixing

Modified a Reference Manual topic.

Patch: DERBY-6643-2.diff

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

Mime
View raw message