[jira] [Created] (CALCITE-5814) Simplify 'a = MAP[1,2] AND a = MAP[2,3]' to 'FALSE'

[Runkang He (Jira)]

Runkang He created CALCITE-5814:
-----------------------------------

             Summary: 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


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.



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