ignite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Pavel Tupitsyn (JIRA)" <j...@apache.org>
Subject [jira] [Created] (IGNITE-4290) SQL: Three-way join returns no results
Date Wed, 23 Nov 2016 17:28:58 GMT
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)

Mime
View raw message