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 18:12:57 GMT
I'll be fun to be able to subscribe and unsubscribe other people :)
But it is not possible.

See http://apache.org/foundation/mailinglists.html

On Wed, Nov 23, 2016 at 9:02 PM, Rohit Gupta <rohitcricket@gmail.com> wrote:

> Thank you, Pavel! Can you please unsubscribe me from the emails?
>
> Thanks,
>
> Rohit
>
> On Wed, Nov 23, 2016 at 9:52 AM, Pavel Tupitsyn <ptupitsyn@apache.org>
> 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 <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