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)