trino icon indicating copy to clipboard operation
trino copied to clipboard

Support ALTER COLUMN SET DATA TYPE statement

Open ebyhr opened this issue 3 years ago • 0 comments
trafficstars

Description

Support ALTER COLUMN SET DATA TYPE statement. ANSI specification:

<alter table statement> ::=
  ALTER TABLE <table name>  <alter table action> 

<alter table action> ::=
...
  | <alter column definition> 

<alter column definition> ::=
ALTER [ COLUMN ] <column name> <alter column action>

<alter column action> ::=
...
  | <alter column data type clause> 

<alter column data type clause> ::=
  SET DATA TYPE <data type> 

Documentation

( ) No documentation is needed. (x) Sufficient documentation is included in this PR. ( ) Documentation PR is available with #prnumber. ( ) Documentation issue #issuenumber is filed, and can be handled later.

Release notes

( ) No release notes entries required. (x) Release notes entries required with the following suggested text:

# General
* Add support for `ALTER COLUMN ... SET DATA TYPE` statement. ({issue}`11608 `)

# MongoDB
* Add support for `ALTER COLUMN ... SET DATA TYPE` statement. ({issue}`11608 `)

Fixes https://github.com/trinodb/trino/issues/10736

ebyhr avatar Mar 22 '22 05:03 ebyhr