ignite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rohit Gupta <rohitcric...@gmail.com>
Subject Re: [jira] [Created] (IGNITE-4292) SQL: Except returns incorrect results
Date Wed, 23 Nov 2016 17:48:07 GMT
Hello,

I am sorry to bother you. I am wondering if I can follow the discussion
online without getting emails. Please let me know.

Thank you!
Sincerely,
Rohit

On Wed, Nov 23, 2016 at 9:34 AM, Pavel Tupitsyn (JIRA) <jira@apache.org>
wrote:

> Pavel Tupitsyn created IGNITE-4292:
> --------------------------------------
>
>              Summary: SQL: Except returns incorrect results
>                  Key: IGNITE-4292
>                  URL: https://issues.apache.org/jira/browse/IGNITE-4292
>              Project: Ignite
>           Issue Type: Bug
>           Components: SQL
>     Affects Versions: 1.8
>             Reporter: Pavel Tupitsyn
>              Fix For: 1.8
>
>
> {code}
> select _T0._key from "".Person as _T0 except (select _T1._foo from
> "role_cache".Role as _T1)
> {code}
>
> 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:
> {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
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message