Thank you, Pavel! Can you please unsubscribe me from the emails? Thanks,
Rohit On Wed, Nov 23, 2016 at 9:52 AM, Pavel Tupitsyn <[email protected]> wrote: > Hi, yes, you can use online mail archives: > http://apache-ignite-developers.2346864.n4.nabble.com/ > > On Wed, Nov 23, 2016 at 8:48 PM, Rohit Gupta <[email protected]> > wrote: > > > 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) <[email protected]> > > 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) > > > > > >
