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

Support standard syntax for altering column nullability

    XMLWordPrintableJSON

    Details

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

      Description

      Derby supports altering the nullability of a column via an ALTER TABLE statement, but the supported syntax is different from what the SQL:2011 standard defines. We should add support for the standard syntax as well.

      The standard syntax is

      ALTER TABLE t ALTER COLUMN c SET NOT NULL
      ALTER TABLE t ALTER COLUMN c DROP NOT NULL

        Attachments

        1. d6644-1a.diff
          9 kB
          Knut Anders Hatlen

          Issue Links

            Activity

              People

              • Assignee:
                knutanders Knut Anders Hatlen
                Reporter:
                knutanders Knut Anders Hatlen
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: