Re: [jira] [Created] (IGNITE-4292) SQL: Except returns incorrect results
Thank you, Pavel!
Rohit
On Wed, Nov 23, 2016 at 10:12 AM, Pavel Tupitsyn
wrote:
> 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
> 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
> > 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
> > > 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) <
> > 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)
> > > > >
> > > >
> > >
> >
>
Re: [jira] [Created] (IGNITE-4292) SQL: Except returns incorrect results
Thank you, Val! I will follow your suggestion.
Rohit
On Wed, Nov 23, 2016 at 10:22 AM, Valentin Kulichenko <
valentin.kuliche...@gmail.com> wrote:
> Hi Rohit,
>
> If you unsubscribe, your messages will not be redirected to the list what
> you post on Nabble, which means that majority of community members will not
> read them. I recommend you to just filter out emails you don't need.
>
> -Val
>
> On Wed, Nov 23, 2016 at 10:12 AM, Pavel Tupitsyn
> wrote:
>
> > 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
> > 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
> > > 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 >
> > > > 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) <
> > > 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)
> > > > > >
> > > > >
> > > >
> > >
> >
>
Re: [jira] [Created] (IGNITE-4292) SQL: Except returns incorrect results
Thank you, Pavel! Can you please unsubscribe me from the emails?
Thanks,
Rohit
On Wed, Nov 23, 2016 at 9:52 AM, Pavel Tupitsyn
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
> 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)
> > 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)
> > >
> >
>
Re: [jira] [Created] (IGNITE-4292) SQL: Except returns incorrect results
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)
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)
>
Please unsubcribe me
unsubscribe
