Pavel Tupitsyn created IGNITE-4290: -------------------------------------- Summary: SQL: Three-way join returns no results Key: IGNITE-4290 URL: https://issues.apache.org/jira/browse/IGNITE-4290 Project: Ignite Issue Type: Bug Components: SQL Affects Versions: 1.8 Reporter: Pavel Tupitsyn Fix For: 1.8
Join three tables (two from the same cache) - no results returned. {code} select _T0._key, _T0._val, _T1._key, _T1._val, _T2._key, _T2._val from "role_cache".Role as _T2 inner join "".Person as _T1 on (_T1._key = _T2._foo) inner join "".Organization as _T0 on (_T0.Id = _T1.OrganizationId) {code} This is CacheLinqTest.TestMulticacheJoin 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)