[ https://issues.apache.org/jira/browse/IGNITE-4289?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Pavel Tupitsyn updated IGNITE-4289: ----------------------------------- Description: 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. Models: {code} CREATE MEMORY TABLE "".PERSON( _KEY INT NOT NULL, _VAL OTHER, AGE1 INT, NAME VARCHAR, ADDRESS OTHER, ZIP INT, STREET VARCHAR, ADDR_ALIASTEST INT, ORGANIZATIONID INT, BIRTHDAY TIMESTAMP, PERSON_ALIASTEST INT ) CREATE MEMORY TABLE "role_cache".ROLE( _KEY OTHER NOT NULL, _VAL OTHER, _FOO INT, _BAR BIGINT, NAME VARCHAR, DATE TIMESTAMP ) CREATE MEMORY TABLE "person_cache".PERSON( _KEY INT NOT NULL, _VAL OTHER, AGE1 INT, NAME VARCHAR, ADDRESS OTHER, ZIP INT, STREET VARCHAR, ALIASTEST INT, ORGANIZATIONID INT, BIRTHDAY TIMESTAMP ) {code} was: 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. > 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. > Models: > {code} > CREATE MEMORY TABLE "".PERSON( > _KEY INT NOT NULL, > _VAL OTHER, > AGE1 INT, > NAME VARCHAR, > ADDRESS OTHER, > ZIP INT, > STREET VARCHAR, > ADDR_ALIASTEST INT, > ORGANIZATIONID INT, > BIRTHDAY TIMESTAMP, > PERSON_ALIASTEST INT > ) > CREATE MEMORY TABLE "role_cache".ROLE( > _KEY OTHER NOT NULL, > _VAL OTHER, > _FOO INT, > _BAR BIGINT, > NAME VARCHAR, > DATE TIMESTAMP > ) > CREATE MEMORY TABLE "person_cache".PERSON( > _KEY INT NOT NULL, > _VAL OTHER, > AGE1 INT, > NAME VARCHAR, > ADDRESS OTHER, > ZIP INT, > STREET VARCHAR, > ALIASTEST INT, > ORGANIZATIONID INT, > BIRTHDAY TIMESTAMP > ) > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)