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

ALTER TABLE columnAlteration syntax needs fixing

    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
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: