[jira] [Created] (CALCITE-6710) Generalize typed literal constant syntax

["Dmitry Sysolyatin (Jira)" <ji...@apache.org>]

Dmitry Sysolyatin created CALCITE-6710:
------------------------------------------

             Summary: Generalize typed literal constant syntax
                 Key: CALCITE-6710
                 URL: https://issues.apache.org/jira/browse/CALCITE-6710
             Project: Calcite
          Issue Type: Improvement
          Components: core
            Reporter: Dmitry Sysolyatin


Calcite supports typed literal constant syntax {{typename 'str'}} for some types, such as DATE and TIMESTAMP, but each of these types has specific parsing logic.

The goal is to generalize this functionality for all types (or nearly all, as even PostgreSQL does not support this syntax for array types), similar to PostgreSQL. For example:
{code:java}
SELECT float32 '10'
{code}
[1] [https://www.postgresql.org/docs/15/sql-syntax-lexical.html#SQL-SYNTAX-CONSTANTS-GENERIC]



--
This message was sent by Atlassian Jira
(v8.20.10#820010)