SQL query doesn't work with binary marshaller

[Andrey Gura]

Guys,

I found problem with SqlQuery and binary objects. TC is green but log for
Ignite Binary Objects Queries plan on ignite-1.5 branch contains errors in
IgniteCacheAbstractQuerySelfTest.testObjectQuery.

The following code leads to empty result because rows have BinaryObjectImpl
type while query arg has ValueObject type (comparison fails):


        IgniteCache<Integer, ObjectValue> cache = ignite().cache(null);

        ObjectValue val = new ObjectValue("test", 0);

        cache.put(1, val);

        QueryCursor<Cache.Entry<Integer, ObjectValue>> qry =
            cache.query(new SqlQuery<Integer,
ObjectValue>(ObjectValue.class, "_val=?").setArgs(val));

        Iterator<Cache.Entry<Integer, ObjectValue>> iter = qry.iterator();
// empty iterator



Is it known issue or I should create a ticket?

--
Andrey Gura
GridGain Systems, Inc.
www.gridgain.com

[Vladimir Ozerov]

This is a known problem, scheduled for 1.6. You can find corresponding
ticket on TC runs - it is mentioned in one of muted Binary Queries tests.
30 дек. 2015 г. 20:04 пользователь "Andrey Gura" <[hidden email]>
написал:

> Guys,
>
> I found problem with SqlQuery and binary objects. TC is green but log for
> Ignite Binary Objects Queries plan on ignite-1.5 branch contains errors in
> IgniteCacheAbstractQuerySelfTest.testObjectQuery.
>
> The following code leads to empty result because rows have BinaryObjectImpl
> type while query arg has ValueObject type (comparison fails):
>
>
>         IgniteCache<Integer, ObjectValue> cache = ignite().cache(null);
>
>         ObjectValue val = new ObjectValue("test", 0);
>
>         cache.put(1, val);
>
>         QueryCursor<Cache.Entry<Integer, ObjectValue>> qry =
>             cache.query(new SqlQuery<Integer,
> ObjectValue>(ObjectValue.class, "_val=?").setArgs(val));
>
>         Iterator<Cache.Entry<Integer, ObjectValue>> iter = qry.iterator();
> // empty iterator
>
>
>
> Is it known issue or I should create a ticket?
>
> --
> Andrey Gura
> GridGain Systems, Inc.
> www.gridgain.com
>

[dsetrakyan]

Vladimir, do you know the ticket number?

On Wed, Dec 30, 2015 at 9:23 AM, Vladimir Ozerov <[hidden email]>
wrote:

> This is a known problem, scheduled for 1.6. You can find corresponding
> ticket on TC runs - it is mentioned in one of muted Binary Queries tests.
> 30 дек. 2015 г. 20:04 пользователь "Andrey Gura" <[hidden email]>
> написал:
>
> > Guys,
> >
> > I found problem with SqlQuery and binary objects. TC is green but log for
> > Ignite Binary Objects Queries plan on ignite-1.5 branch contains errors
> in
> > IgniteCacheAbstractQuerySelfTest.testObjectQuery.
> >
> > The following code leads to empty result because rows have
> BinaryObjectImpl
> > type while query arg has ValueObject type (comparison fails):
> >
> >
> >         IgniteCache<Integer, ObjectValue> cache = ignite().cache(null);
> >
> >         ObjectValue val = new ObjectValue("test", 0);
> >
> >         cache.put(1, val);
> >
> >         QueryCursor<Cache.Entry<Integer, ObjectValue>> qry =
> >             cache.query(new SqlQuery<Integer,
> > ObjectValue>(ObjectValue.class, "_val=?").setArgs(val));
> >
> >         Iterator<Cache.Entry<Integer, ObjectValue>> iter =
> qry.iterator();
> > // empty iterator
> >
> >
> >
> > Is it known issue or I should create a ticket?
> >
> > --
> > Andrey Gura
> > GridGain Systems, Inc.
> > www.gridgain.com
> >
>

[Vladimir Ozerov]

Yes, here it is - https://issues.apache.org/jira/browse/IGNITE-2208

On Thu, Dec 31, 2015 at 1:05 AM, Dmitriy Setrakyan <[hidden email]>
wrote:

> Vladimir, do you know the ticket number?
>
> On Wed, Dec 30, 2015 at 9:23 AM, Vladimir Ozerov <[hidden email]>
> wrote:
>
> > This is a known problem, scheduled for 1.6. You can find corresponding
> > ticket on TC runs - it is mentioned in one of muted Binary Queries tests.
> > 30 дек. 2015 г. 20:04 пользователь "Andrey Gura" <[hidden email]>
> > написал:
> >
> > > Guys,
> > >
> > > I found problem with SqlQuery and binary objects. TC is green but log
> for
> > > Ignite Binary Objects Queries plan on ignite-1.5 branch contains errors
> > in
> > > IgniteCacheAbstractQuerySelfTest.testObjectQuery.
> > >
> > > The following code leads to empty result because rows have
> > BinaryObjectImpl
> > > type while query arg has ValueObject type (comparison fails):
> > >
> > >
> > >         IgniteCache<Integer, ObjectValue> cache = ignite().cache(null);
> > >
> > >         ObjectValue val = new ObjectValue("test", 0);
> > >
> > >         cache.put(1, val);
> > >
> > >         QueryCursor<Cache.Entry<Integer, ObjectValue>> qry =
> > >             cache.query(new SqlQuery<Integer,
> > > ObjectValue>(ObjectValue.class, "_val=?").setArgs(val));
> > >
> > >         Iterator<Cache.Entry<Integer, ObjectValue>> iter =
> > qry.iterator();
> > > // empty iterator
> > >
> > >
> > >
> > > Is it known issue or I should create a ticket?
> > >
> > > --
> > > Andrey Gura
> > > GridGain Systems, Inc.
> > > www.gridgain.com
> > >
> >
>

[Konstantin Boudnik-2]

I have reported what might be a similar issue on the separate thread with subj
    "Differences in default marshaller"

Cos

On Mon, Jan 04, 2016 at 01:39PM, Vladimir Ozerov wrote:

> Yes, here it is - https://issues.apache.org/jira/browse/IGNITE-2208
>
> On Thu, Dec 31, 2015 at 1:05 AM, Dmitriy Setrakyan <[hidden email]>
> wrote:
>
> > Vladimir, do you know the ticket number?
> >
> > On Wed, Dec 30, 2015 at 9:23 AM, Vladimir Ozerov <[hidden email]>
> > wrote:
> >
> > > This is a known problem, scheduled for 1.6. You can find corresponding
> > > ticket on TC runs - it is mentioned in one of muted Binary Queries tests.
> > > 30 дек. 2015 г. 20:04 пользователь "Andrey Gura" <[hidden email]>
> > > написал:
> > >
> > > > Guys,
> > > >
> > > > I found problem with SqlQuery and binary objects. TC is green but log
> > for
> > > > Ignite Binary Objects Queries plan on ignite-1.5 branch contains errors
> > > in
> > > > IgniteCacheAbstractQuerySelfTest.testObjectQuery.
> > > >
> > > > The following code leads to empty result because rows have
> > > BinaryObjectImpl
> > > > type while query arg has ValueObject type (comparison fails):
> > > >
> > > >
> > > >         IgniteCache<Integer, ObjectValue> cache = ignite().cache(null);
> > > >
> > > >         ObjectValue val = new ObjectValue("test", 0);
> > > >
> > > >         cache.put(1, val);
> > > >
> > > >         QueryCursor<Cache.Entry<Integer, ObjectValue>> qry =
> > > >             cache.query(new SqlQuery<Integer,
> > > > ObjectValue>(ObjectValue.class, "_val=?").setArgs(val));
> > > >
> > > >         Iterator<Cache.Entry<Integer, ObjectValue>> iter =
> > > qry.iterator();
> > > > // empty iterator
> > > >
> > > >
> > > >
> > > > Is it known issue or I should create a ticket?
> > > >
> > > > --
> > > > Andrey Gura
> > > > GridGain Systems, Inc.
> > > > www.gridgain.com
> > > >
> > >
> >