[ https://issues.apache.org/jira/browse/IGNITE-19406?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Pavel Pereslegin updated IGNITE-19406: -------------------------------------- Description: Describe ALTER COLUMN grammar for SQL query parser. Describe expected behaviour in tests. SQL API example: {code:sql} -- Change default. ALTER TABLE tbl ALTER COLUMN mycolumn SET DEFAULT 10; ALTER TABLE tbl ALTER COLUMN mycolumn DROP DEFAULT; -- Change nullable. ALTER TABLE tbl ALTER COLUMN mycolumn SET NOT NULL; ALTER TABLE tbl ALTER COLUMN mycolumn DROP NOT NULL; -- Change data type. ALTER TABLE tbl ALTER COLUMN mycolumn SET DATA TYPE LONG; ALTER TABLE tbl ALTER COLUMN mycolumn SET DATA TYPE LONG DEFAULT -1; ALTER TABLE tbl ALTER COLUMN mycolumn SET DATA TYPE LONG NOT NULL; ALTER TABLE tbl ALTER COLUMN mycolumn SET DATA TYPE LONG NOT NULL DEFAULT -1; {code} was: Describe ALTER COLUMN grammar for SQL query parser. Describe expected behaviour in tests. SQL API example: {code:sql} -- Change default. ALTER TABLE tbl ALTER COLUMN mycolumn SET DEFAULT 10; ALTER TABLE tbl ALTER COLUMN mycolumn DROP DEFAULT; -- Change nullable. ALTER TABLE tbl ALTER COLUMN mycolumn SET NOT NULL; ALTER TABLE tbl ALTER COLUMN mycolumn DROP NOT NULL; -- Change data type. ALTER TABLE tbl ALTER COLUMN mycolumn DATA TYPE LONG; ALTER TABLE tbl ALTER COLUMN mycolumn DATA TYPE LONG DEFAULT -1; ALTER TABLE tbl ALTER COLUMN mycolumn DATA TYPE LONG NOT NULL; ALTER TABLE tbl ALTER COLUMN mycolumn DATA TYPE LONG NOT NULL DEFAULT -1; {code} > Sql. Support ALTER TABLE ALTER COLUMN TYPE. > ------------------------------------------- > > Key: IGNITE-19406 > URL: https://issues.apache.org/jira/browse/IGNITE-19406 > Project: Ignite > Issue Type: Improvement > Components: sql > Reporter: Andrey Mashenkov > Assignee: Pavel Pereslegin > Priority: Major > Labels: ignite-3 > Time Spent: 10m > Remaining Estimate: 0h > > Describe ALTER COLUMN grammar for SQL query parser. > Describe expected behaviour in tests. > SQL API example: > {code:sql} > -- Change default. > ALTER TABLE tbl ALTER COLUMN mycolumn SET DEFAULT 10; > ALTER TABLE tbl ALTER COLUMN mycolumn DROP DEFAULT; > -- Change nullable. > ALTER TABLE tbl ALTER COLUMN mycolumn SET NOT NULL; > ALTER TABLE tbl ALTER COLUMN mycolumn DROP NOT NULL; > -- Change data type. > ALTER TABLE tbl ALTER COLUMN mycolumn SET DATA TYPE LONG; > ALTER TABLE tbl ALTER COLUMN mycolumn SET DATA TYPE LONG DEFAULT -1; > ALTER TABLE tbl ALTER COLUMN mycolumn SET DATA TYPE LONG NOT NULL; > ALTER TABLE tbl ALTER COLUMN mycolumn SET DATA TYPE LONG NOT NULL DEFAULT -1; > {code} -- This message was sent by Atlassian Jira (v8.20.10#820010)