[jira] [Updated] (IGNITE-23234) H2 does not support multiple fields in WHERE ... IN expression

["Ilya Shishkov (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IGNITE-23234?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ilya Shishkov updated IGNITE-23234:
-----------------------------------
    Summary: H2 does not support multiple fields in WHERE ... IN expression  (was: H2 does not support multiple fields in WHERE ...IN expression)

> H2 does not support multiple fields in WHERE ... IN expression
> --------------------------------------------------------------
>
>                 Key: IGNITE-23234
>                 URL: https://issues.apache.org/jira/browse/IGNITE-23234
>             Project: Ignite
>          Issue Type: Bug
>            Reporter: Ilya Shishkov
>            Priority: Minor
>              Labels: ise
>         Attachments: IGNITE-23234.patch
>
>
> Such expression:
> {code}
> SELECT * FROM first WHERE (name, city) IN (select name, city from second)
> {code}
> fails with a following error:
> {code}
> class org.apache.ignite.internal.processors.query.IgniteSQLException: Failed to parse query. 
> Subquery is not a single column query; 
> {code}
> Calcite handles such query correctly. See attached reproducer:  [^IGNITE-23234.patch] 



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