ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alexander Paschenko (JIRA)" <j...@apache.org>
Subject [jira] [Assigned] (IGNITE-4290) SQL: Three-way join returns no results
Date Thu, 24 Nov 2016 10:14:59 GMT

     [ https://issues.apache.org/jira/browse/IGNITE-4290?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Alexander Paschenko reassigned IGNITE-4290:
-------------------------------------------

    Assignee: Alexander Paschenko

> 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
>            Assignee: Alexander Paschenko
>             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