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

ALTER TABLE columnAlteration syntax needs fixing

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 10.11.1.1
    • 10.11.1.1
    • Documentation
    • 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

              chaase3 Camilla Haase
              chaase3 Camilla Haase
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: