[
https://issues.apache.org/jira/browse/IGNITE-20907?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roman Puchkovskiy updated IGNITE-20907:
---------------------------------------
Summary: Support column type changes that do not require existing data
conversion (was: Add column value conversions not supported by BinaryTuple)
> Support column type changes that do not require existing data conversion
> ------------------------------------------------------------------------
>
> Key: IGNITE-20907
> URL: https://issues.apache.org/jira/browse/IGNITE-20907
> Project: Ignite
> Issue Type: Improvement
> Components: sql
> Reporter: Roman Puchkovskiy
> Priority: Major
> Labels: ignite-3
>
> CREATE TABLE t (id INT PRIMARY KEY, val INT NOT NULL);
> ALTER TABLE t ALTER COLUMN val SET DATA TYPE VARCHAR;
> Second query fails with 'Changing the type from INT32 to STRING is not
> allowed'. Also, it's not possible to change type to DECIMAL.
> Currently, we only support data type changes that do not require existing
> table data conversion; instead, we upgrade the column values (when needed) on
> read.
> But current implementation is even more strict: it only allows conversions
> directly supported by BinaryTuple class (like int->long).
> A mechanism for additional conversions should be added. It will allow
> conversions to VARCHAR.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
