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:28:58 UTC
[jira] [Created] (IGNITE-4290) SQL: Three-way join returns no
results
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)