[
https://issues.apache.org/jira/browse/IGNITE-4291?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vladimir Ozerov reopened IGNITE-4291:
-------------------------------------
> SQL: Multi-from join returns no results
> ---------------------------------------
>
> Key: IGNITE-4291
> URL: https://issues.apache.org/jira/browse/IGNITE-4291
> Project: Ignite
> Issue Type: Bug
> Components: SQL
> Affects Versions: 1.8
> Reporter: Pavel Tupitsyn
> Assignee: Alexander Paschenko
> Fix For: 1.8
>
>
> {code}
> select _T0.Name, _T1.Name from "".Person as _T0 , "role_cache".Role as _T1
> where (_T0._key < ?) and (_T0._key = _T1._foo)
> {code}
> This is CacheLinqTest.TestMultipleFrom 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)
