[jira] [Created] (CALCITE-598) Add Maps / Collection support in WHERE clause

["Vladimir Dolzhenko (JIRA)" <ji...@apache.org>]

Vladimir Dolzhenko created CALCITE-598:
------------------------------------------

             Summary: Add Maps / Collection support in WHERE clause
                 Key: CALCITE-598
                 URL: https://issues.apache.org/jira/browse/CALCITE-598
             Project: Calcite
          Issue Type: Improvement
            Reporter: Vladimir Dolzhenko
            Assignee: Julian Hyde


I'd like to be able to use maps (and collections) in WHERE clause like
{code}
select * from myTable where type = MAP['key', 'value']
{code}

Actually it fails with
{code}
java.sql.SQLException: error while executing SQL "select * from myTable where type = MAP['a', 'b']": From line 1, column 28 to line 1, column 48: Cannot apply '=' to arguments of type '<JAVATYPE(INTERFACE JAVA.UTIL.MAP)> = <(CHAR(1), CHAR(1)) MAP>'. Supported form(s): '<COMPARABLE_TYPE> = <COMPARABLE_TYPE>'
{code}

As well I tried "type IS MAP[..." and "type IS A MAP[..."



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)