Apache Ignite Developers - Legacy Mail Archive

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

Classic

List

Threaded

8 messages Options

Anton Vinogradov (Jira)

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

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)

Rohit Gupta

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) <[hidden email]>
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)
>

Pavel Tupitsyn

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

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 <[hidden email]> 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) <[hidden email]>
> 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)
> >
>

Rohit Gupta

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 <[hidden email]>
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 <[hidden email]>
> 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) <[hidden email]>
> > 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)
> > >
> >
>

Pavel Tupitsyn

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

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 <[hidden email]> 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 <[hidden email]>
> 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 <[hidden email]>
> > 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) <
> [hidden email]>
> > > 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)
> > > >
> > >
> >
>

Valentin Kulichenko

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

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 <[hidden email]>
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 <[hidden email]>
> 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 <[hidden email]>
> > 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 <[hidden email]>
> > > 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) <
> > [hidden email]>
> > > > 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)
> > > > >
> > > >
> > >
> >
>

Rohit Gupta

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 <
[hidden email]> 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 <[hidden email]>
> 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 <[hidden email]>
> > 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 <[hidden email]>
> > > 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 <[hidden email]
> >
> > > > 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) <
> > > [hidden email]>
> > > > > 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)
> > > > > >
> > > > >
> > > >
> > >
> >
>

Rohit Gupta

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

In reply to this post by Pavel Tupitsyn

Thank you, Pavel!

Rohit

On Wed, Nov 23, 2016 at 10:12 AM, Pavel Tupitsyn <[hidden email]>
wrote: