[
https://issues.apache.org/jira/browse/CALCITE-5814?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Runkang He updated CALCITE-5814:
--------------------------------
Description:
Currently the following expression with const map literal is not simplified to
FALSE:
{code:sql}
a = MAP[1,2] AND a = MAP[2,3]
{code}
Since the map type is an extension to the SQL standard, it's not clear whether
it is comparable or not. If comparable, it would be nice to simplify above
expression to FALSE.
Welcome to discuss or provide some information.
Note that this Jira is inspired from discussion of
was:
Currently the following expression with const map literal is not simplified to
FALSE:
{code:sql}
a = MAP[1,2] AND a = MAP[2,3]
{code}
Since the map type is an extension to the SQL standard, it's not clear whether
it is comparable or not. If comparable, it would be nice to simplify above
expression to FALSE.
Welcome to discuss or provide some information.
> Simplify 'a = MAP[1,2] AND a = MAP[2,3]' to 'FALSE'
> ---------------------------------------------------
>
> Key: CALCITE-5814
> URL: https://issues.apache.org/jira/browse/CALCITE-5814
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Affects Versions: 1.34.0
> Reporter: Runkang He
> Assignee: Runkang He
> Priority: Major
>
> Currently the following expression with const map literal is not simplified
> to FALSE:
> {code:sql}
> a = MAP[1,2] AND a = MAP[2,3]
> {code}
> Since the map type is an extension to the SQL standard, it's not clear
> whether it is comparable or not. If comparable, it would be nice to simplify
> above expression to FALSE.
> Welcome to discuss or provide some information.
> Note that this Jira is inspired from discussion of
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
