ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Pavel Tupitsyn (JIRA)" <j...@apache.org>
Subject [jira] [Created] (IGNITE-7446) Distributed joins do not work with DML and IN clause
Date Wed, 17 Jan 2018 08:11:03 GMT
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)

Mime
View raw message