[2.7.6] Bug with query parallelization + sorting nulls

classic Classic list List threaded Threaded
3 messages Options
maxi628 maxi628
Reply | Threaded
Open this post in threaded view
|

[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/
Ilya Kazakov Ilya Kazakov
Reply | Threaded
Open this post in threaded view
|

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

Thank you, Maxi!

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

----------
Ilya

пт, 12 февр. 2021 г. в 22:13, maxi628 <[hidden email]>:
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/
Ilya Kazakov Ilya Kazakov
Reply | Threaded
Open this post in threaded view
|

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

Hello, Maxi!

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

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

пн, 15 февр. 2021 г. в 13:38, Ilya Kazakov <[hidden email]>:
Thank you, Maxi!

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

----------
Ilya

пт, 12 февр. 2021 г. в 22:13, maxi628 <[hidden email]>:
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/