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)