[DERBY-6644] Support standard syntax for altering column nullability

• 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
• Assignee: Knut Anders Hatlen
• Reporter: Knut Anders Hatlen
• Created: 02/Jul/14 09:22
• Updated: 09/Sep/16 09:51
• Resolved: 03/Jul/14 07:50

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

Issue Links

• is related to: DERBY-6643 ALTER TABLE columnAlteration syntax needs fixing