[jira] [Created] (IGNITE-7446) Distributed joins do not work with DML and IN clause

["Pavel Tupitsyn (JIRA)" <ji...@apache.org>]

Pavel Tupitsyn created IGNITE-7446:
--------------------------------------

             Summary: Distributed joins do not work with DML and IN clause
                 Key: IGNITE-7446
                 URL: https://issues.apache.org/jira/browse/IGNITE-7446
             Project: Ignite
          Issue Type: Bug
          Components: sql
    Affects Versions: 2.4
            Reporter: Pavel Tupitsyn


If we want to delete a set of records determined by a JOIN query, the only way ( ? ) in Ignite is to wrap that JOIN query inside IN clause like this:

{code}
delete from Employee where _key in (select emp._key from Employee emp, Organization org where org.Name != ? and org._key = emp.organizationId)
{code}

But {{distributedJoins}} flag does not work in this case, so incorrect result is possible.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)