Roman Puchkovskiy created IGNITE-20905:
------------------------------------------
Summary: Make it possible to add an explicitly NULL column via ADD
COLUMN
Key: IGNITE-20905
URL: https://issues.apache.org/jira/browse/IGNITE-20905
Project: Ignite
Issue Type: Improvement
Components: sql
Reporter: Roman Puchkovskiy
When creating a table, it's possible to specify that a column is nullable by
explicitly using NULL:
CREATE TABLE t(id INT PRIMARY KEY, col1 INT NULL)
But, if we add a column to an existing table, this does not work:
ALTER TABLE t ADD COLUMN col2 INT NULL
-> Failed to parse query: Encountered "NULL" at line 1, column X
It seems that for consistency ADD COLUMN should support same syntax as CREATE
TABLE does.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
