You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ignite.apache.org by "Pavel Tupitsyn (JIRA)" <ji...@apache.org> on 2016/11/23 17:20:58 UTC

[jira] [Created] (IGNITE-4289) SQL: Intersect with subquery returns no results

Pavel Tupitsyn created IGNITE-4289:
--------------------------------------

             Summary: SQL: Intersect with subquery returns no results
                 Key: IGNITE-4289
                 URL: https://issues.apache.org/jira/browse/IGNITE-4289
             Project: Ignite
          Issue Type: Bug
          Components: SQL
    Affects Versions: 1.8
            Reporter: Pavel Tupitsyn
             Fix For: 1.8


Whole entry intersect works:
{code}
select _T0._key, _T0._val from "".Person as _T0 intersect (select _T1._key, _T1._val from "person_cache".Person as _T1)
{code}

but subquery intersect does not:
{code}
select _T0._key from "".Person as _T0 intersect (select _T1._foo from "role_cache".Role as _T1)
{code}

This is CacheLinqTest.TestIntersect in "Ignite Platform .NET" suite. Works in master, does not work in ignite-1.8 after DML merge.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)