You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Vladimir Ozerov (JIRA)" <ji...@apache.org> on 2019/02/15 08:28:00 UTC
[jira] [Closed] (IGNITE-10471) SQL: ADD COLUMN doesn't support user
types but DROP COLUMN does
[ https://issues.apache.org/jira/browse/IGNITE-10471?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vladimir Ozerov closed IGNITE-10471.
------------------------------------
> SQL: ADD COLUMN doesn't support user types but DROP COLUMN does
> ---------------------------------------------------------------
>
> Key: IGNITE-10471
> URL: https://issues.apache.org/jira/browse/IGNITE-10471
> Project: Ignite
> Issue Type: Improvement
> Components: sql
> Affects Versions: 2.6
> Reporter: Andrey Aleksandrov
> Priority: Minor
> Fix For: 2.8
>
>
> 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.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)