Re: [jira] [Created] (IGNITE-4292) SQL: Except returns incorrect results

[Rohit Gupta]

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

[Valentin Kulichenko]

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

[Rohit Gupta]

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

[Pavel Tupitsyn]

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

[Rohit Gupta]

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)
>

[jira] [Created] (IGNITE-4292) SQL: Except returns incorrect results

[Pavel Tupitsyn (JIRA)]

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)