[
https://issues.apache.org/jira/browse/IGNITE-23234?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ilya Shishkov updated IGNITE-23234:
-----------------------------------
Description:
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]
was:
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:
> H2 does not support multiple fields in WHERE operator
> -----------------------------------------------------
>
> Key: IGNITE-23234
> URL: https://issues.apache.org/jira/browse/IGNITE-23234
> Project: Ignite
> Issue Type: Bug
> Reporter: Ilya Shishkov
> Priority: Minor
> 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)
