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

[Runkang He (Jira)]

Runkang He created CALCITE-5815:
-----------------------------------

             Summary: Simplify 'a = MULTISET[1,2] AND a = MULTISET[2,3]' to 
'FALSE'
                 Key: CALCITE-5815
                 URL: https://issues.apache.org/jira/browse/CALCITE-5815
             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 = MULTISET[1,2] AND a = MULTISET[2,3]
{code}

Since MULTISET type is comparable according to ANSI SQL standard, it would be 
nice to simplify above expression to FALSE.



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