Ilya Shishkov created IGNITE-23234:
--------------------------------------

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


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}



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

Reply via email to