babelfish-for-postgresql / babelfish_extensions / 17603910055

77%

push

github

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

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
Signed-off-by: Rahul Parande <rparande@amazon.com>

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

50435 of 66094 relevant lines covered (76.31%)

383329.15 hits per line