You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "Julian Hyde (Jira)" <ji...@apache.org> on 2021/12/03 00:38:00 UTC

[jira] [Created] (CALCITE-4918) Add a VARIANT data type

Julian Hyde created CALCITE-4918:
------------------------------------

             Summary: Add a VARIANT data type
                 Key: CALCITE-4918
                 URL: https://issues.apache.org/jira/browse/CALCITE-4918
             Project: Calcite
          Issue Type: Bug
            Reporter: Julian Hyde


Add a VARIANT data type. It would be a tagged union, and allow values of multiple types to be stored, along with a type indicator so that the actual type of each value can be discerned.

VARIANT is not in the SQL standard. I know of three databases that have a VARIANT type: MSSQL, Snowflake, Teradata. Calcite's VARIANT type will probably draw from all three; however, the goal is not full compliance with any of them, but useful functionality.



--
This message was sent by Atlassian Jira
(v8.20.1#820001)