You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@ignite.apache.org by "Aleksey Plekhanov (Jira)" <ji...@apache.org> on 2021/12/08 12:45:00 UTC

[jira] [Created] (IGNITE-16085) Calcite engine. Index can't be used with IS NULL condition

Aleksey Plekhanov created IGNITE-16085:
------------------------------------------

             Summary: Calcite engine. Index can't be used with IS NULL condition
                 Key: IGNITE-16085
                 URL: https://issues.apache.org/jira/browse/IGNITE-16085
             Project: Ignite
          Issue Type: Improvement
            Reporter: Aleksey Plekhanov


Currently, we support only {{EQUALS}}, {{LESS_THAN}}, {{GREATER_THAN}}, {{GREATER_THAN_OR_EQUAL}}, {{LESS_THAN_OR_EQUAL}} conditions for index scans. Our indexes also can be scanned for null values by design, but full table scan now performed for {{IS NULL}} condition on indexed fields. 



--
This message was sent by Atlassian Jira
(v8.20.1#820001)