ignite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Pavel Tupitsyn <ptupit...@apache.org>
Subject Re: [jira] [Created] (IGNITE-4292) SQL: Except returns incorrect results
Date Wed, 23 Nov 2016 17:52:16 GMT
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 <rohitcricket@gmail.com> 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) <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