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