Roman Puchkovskiy created IGNITE-20907:
------------------------------------------
Summary: Add column value conversions not supported by BinaryTuple
Key: IGNITE-20907
URL: https://issues.apache.org/jira/browse/IGNITE-20907
Project: Ignite
Issue Type: Improvement
Components: sql
Reporter: Roman Puchkovskiy
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)
