You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Mikhail Cherkasov (JIRA)" <ji...@apache.org> on 2018/02/07 01:49:00 UTC
[jira] [Created] (IGNITE-7642) Ignite fails with OOM if query has
"NULLS LAST"
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)