[IGNITE-10471] SQL: ADD COLUMN doesn't support user types but DROP COLUMN does

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Won't Fix
• Affects Version/s: 2.6
• Fix Version/s: 2.8
• Component/s: sql
• Assignee: Unassigned
• Reporter: Andrei Aleksandrov
• Created: 29/Nov/18 12:42
• Updated: 15/Feb/19 08:27
• Resolved: 15/Feb/19 08:27

Description

Looks like ALTER COLUMN commands could be used only on a subset of supported types (that could be used in CREATE TABLE syntax):

https://apacheignite-sql.readme.io/docs/data-types

But using query entities we can provide to use a field that has user types.

This fields can be used in 

ALTER TABLE CACHE_NAME DROP COLUMN COLUMN_NAME

But it can't be used as next:

ALTER TABLE CACHE_NAME  ADD COLUMN COLUMN_NAME 'type'

Where type is a user's one.

Possible we should think about supporting POJO and enums.