Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-6643

ALTER TABLE columnAlteration syntax needs fixing

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 10.11.1.1
    • Fix Version/s: 10.11.1.1
    • Component/s: Documentation
    • Labels:
      None

      Description

      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.

        Attachments

        1. DERBY-6643.diff
          1 kB
          Camilla Haase
        2. DERBY-6643-2.diff
          0.6 kB
          Camilla Haase
        3. rrefsqlj81859.html
          20 kB
          Camilla Haase
        4. rrefsqlj81859.html
          20 kB
          Camilla Haase

        Issue Links

          Activity

            People

            • Assignee:
              chaase3 Camilla Haase
              Reporter:
              chaase3 Camilla Haase

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment