You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by maxi628 <ma...@gmail.com> on 2021/02/12 14:13:39 UTC

[2.7.6] Bug with query parallelization + sorting nulls

Hello everyone, I think I've found a bug.

I created a test to reproduce it.
Basically, it creates two caches, one with *queryParallelization=1* and
another one with *queryParallelization=8*.
And I compare results from this query *"SELECT ID FROM TEST ORDER BY
NULLABLE_VALUE ASC NULLS LAST"* and it fails. 
Looks like when *queryParallelization > 1* NULLS LAST has no effect.

I'm attaching a test that I wrote to reproduce.

SortingByNull.java
<http://apache-ignite-users.70518.x6.nabble.com/file/t3058/SortingByNull.java>  

Thanks.



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: [2.7.6] Bug with query parallelization + sorting nulls

Posted by Ilya Kazakov <ka...@gmail.com>.
Hello, Maxi!

The issue was reported: https://issues.apache.org/jira/browse/IGNITE-14177

------------
Ilya

пн, 15 февр. 2021 г. в 13:38, Ilya Kazakov <ka...@gmail.com>:

> Thank you, Maxi!
>
> It really looks like a bug. I will report it!
>
> ----------
> Ilya
>
> пт, 12 февр. 2021 г. в 22:13, maxi628 <ma...@gmail.com>:
>
>> Hello everyone, I think I've found a bug.
>>
>> I created a test to reproduce it.
>> Basically, it creates two caches, one with *queryParallelization=1* and
>> another one with *queryParallelization=8*.
>> And I compare results from this query *"SELECT ID FROM TEST ORDER BY
>> NULLABLE_VALUE ASC NULLS LAST"* and it fails.
>> Looks like when *queryParallelization > 1* NULLS LAST has no effect.
>>
>> I'm attaching a test that I wrote to reproduce.
>>
>> SortingByNull.java
>> <
>> http://apache-ignite-users.70518.x6.nabble.com/file/t3058/SortingByNull.java>
>>
>>
>> Thanks.
>>
>>
>>
>> --
>> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>>
>

Re: [2.7.6] Bug with query parallelization + sorting nulls

Posted by Ilya Kazakov <ka...@gmail.com>.
Thank you, Maxi!

It really looks like a bug. I will report it!

----------
Ilya

пт, 12 февр. 2021 г. в 22:13, maxi628 <ma...@gmail.com>:

> Hello everyone, I think I've found a bug.
>
> I created a test to reproduce it.
> Basically, it creates two caches, one with *queryParallelization=1* and
> another one with *queryParallelization=8*.
> And I compare results from this query *"SELECT ID FROM TEST ORDER BY
> NULLABLE_VALUE ASC NULLS LAST"* and it fails.
> Looks like when *queryParallelization > 1* NULLS LAST has no effect.
>
> I'm attaching a test that I wrote to reproduce.
>
> SortingByNull.java
> <
> http://apache-ignite-users.70518.x6.nabble.com/file/t3058/SortingByNull.java>
>
>
> Thanks.
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>