Mikhail Cherkasov created IGNITE-7642:
-----------------------------------------
Summary: Ignite fails with OOM if query has "NULLS LAST"
Key: IGNITE-7642
URL: https://issues.apache.org/jira/browse/IGNITE-7642
Project: Ignite
Issue Type: Bug
Components: sql
Affects Versions: 2.3
Reporter: Mikhail Cherkasov
Fix For: 2.5
Attachments: OrderByNullsLastTest.java
I have an index for "a" filed of "A" type and the following SQL works fine:
SELECT * FROM A ORDER BY a LIMIT 0 + 50
but as soon as I added "NULLS LAST" it starts to fail with OOM error:
SELECT * FROM A WHERE a is not null ORDER BY a LIMIT 0 + 50
However for both queries, EXPLAIN says that it the uses index, I don't see why
it should fail, but looks like ignite tryes to load all memory into heap and
sort there, and this leads to OOM.
A reproducer is attached.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
