[IGNITE-4292] SQL: Except returns incorrect results

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 1.8
• Fix Version/s: 1.8
• Component/s: sql
• Assignee: Alexander Paschenko
• Reporter: Pavel Tupitsyn
• Created: 23/Nov/16 17:34
• Updated: 24/Nov/16 15:58
• Resolved: 24/Nov/16 15:58

Description

select _T0._key from "".Person as _T0 except (select _T1._foo from "role_cache".Role as _T1)

Returns all keys even though some are present in both tables.

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

Models:

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
)

Issue Links

• duplicates: IGNITE-4280 Fix failing tests in IgniteBinaryCacheQueryTestSuite