You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-dev@db.apache.org by "Knut Anders Hatlen (JIRA)" <ji...@apache.org> on 2014/07/02 11:23:24 UTC

[jira] [Created] (DERBY-6644) Support standard syntax for altering column nullability

Knut Anders Hatlen created DERBY-6644:
-----------------------------------------

             Summary: Support standard syntax for altering column nullability
                 Key: DERBY-6644
                 URL: https://issues.apache.org/jira/browse/DERBY-6644
             Project: Derby
          Issue Type: Improvement
          Components: SQL
    Affects Versions: 10.11.0.0
            Reporter: Knut Anders Hatlen
            Assignee: Knut Anders Hatlen
            Priority: Minor


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



--
This message was sent by Atlassian JIRA
(v6.2#6252)