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) <j...@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) >
