babelfish-for-postgresql / babelfish_extensions / 17629084774

76%

BABEL_5_X_DEV: 77%

push

github

Fix ALTER TABLE ALTER COLUMN NULL/NOT NULL syntax support in Babelfish (#4070)

Description
Today, Babelfish doesn't support T-SQL's ALTER TABLE ALTER COLUMN syntax for modifying column nullability.
Syntax:

ALTER TABLE table_name ALTER COLUMN <column_name> <datatype> NULL
ALTER TABLE table_name ALTER COLUMN <column_name> <datatype> NOT NULL
This PR implements support for the NULL/NOT NULL syntax in ALTER TABLE ALTER COLUMN statements

Changes:
Added grammar rules (opt_null_constraint)to recognize the NULL and NOT NULL modifiers in ALTER COLUMN statements
Uses PostgreSQLs existing AT_SetNotNull and AT_DropNotNull commands to implement the functionality

Issues Resolved BABEL-3966
Issue Link: #2771
Signed off: Rahul Parande rparande@amazon.com

18 of 22 new or added lines in 1 file covered. (81.82%)

49822 of 65572 relevant lines covered (75.98%)

383698.92 hits per line