You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Roman Puchkovskiy (Jira)" <ji...@apache.org> on 2023/11/21 10:21:00 UTC

[jira] [Created] (IGNITE-20907) Add column value conversions not supported by BinaryTuple

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)