ignite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrey Aleksandrov (JIRA)" <j...@apache.org>
Subject [jira] [Created] (IGNITE-10471) SQL: Alter table to add column sytax doesn't support the user types but drop column can drop such fields
Date Thu, 29 Nov 2018 12:43:00 GMT
Andrey Aleksandrov created IGNITE-10471:
-------------------------------------------

             Summary: SQL: Alter table to add column sytax doesn't support the user types
but drop column can drop such fields
                 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
             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)

Mime
View raw message