[
https://issues.apache.org/jira/browse/CALCITE-6710?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dmitry Sysolyatin updated CALCITE-6710:
---------------------------------------
Description:
Calcite supports typed literal constant syntax {{<typename> <character
literal>}} 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]
was:
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]
> 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
> Priority: Major
>
> Calcite supports typed literal constant syntax {{<typename> <character
> literal>}} 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)
