[jira] [Updated] (IGNITE-19406) Sql. Support ALTER TABLE ALTER COLUMN TYPE.

[Pavel Pereslegin (Jira)]

     [ 
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)