You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Pavel Tupitsyn (JIRA)" <ji...@apache.org> on 2016/11/23 17:24:58 UTC
[jira] [Updated] (IGNITE-4289) SQL: Intersect with subquery returns no results

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

Pavel Tupitsyn updated IGNITE-4289:
-----------------------------------
    Description: 
Whole entry intersect works:
{code}
select _T0._key, _T0._val from "".Person as _T0 intersect (select _T1._key, _T1._val from "person_cache".Person as _T1)
{code}

but subquery intersect does not:
{code}
select _T0._key from "".Person as _T0 intersect (select _T1._foo from "role_cache".Role as _T1)
{code}

This is CacheLinqTest.TestIntersect 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}

  was:
Whole entry intersect works:
{code}
select _T0._key, _T0._val from "".Person as _T0 intersect (select _T1._key, _T1._val from "person_cache".Person as _T1)
{code}

but subquery intersect does not:
{code}
select _T0._key from "".Person as _T0 intersect (select _T1._foo from "role_cache".Role as _T1)
{code}

This is CacheLinqTest.TestIntersect in "Ignite Platform .NET" suite. Works in master, does not work in ignite-1.8 after DML merge.


> SQL: Intersect with subquery returns no results
> -----------------------------------------------
>
>                 Key: IGNITE-4289
>                 URL: https://issues.apache.org/jira/browse/IGNITE-4289
>             Project: Ignite
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 1.8
>            Reporter: Pavel Tupitsyn
>             Fix For: 1.8
>
>
> Whole entry intersect works:
> {code}
> select _T0._key, _T0._val from "".Person as _T0 intersect (select _T1._key, _T1._val from "person_cache".Person as _T1)
> {code}
> but subquery intersect does not:
> {code}
> select _T0._key from "".Person as _T0 intersect (select _T1._foo from "role_cache".Role as _T1)
> {code}
> This is CacheLinqTest.TestIntersect 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)