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

Posted to issues@ignite.apache.org by "Alexander Belyak (Jira)" <ji...@apache.org> on 2021/06/02 09:23:00 UTC

[jira] [Created] (IGNITE-14813) Use statistics with not null where clauses

Alexander Belyak created IGNITE-14813:
-----------------------------------------

             Summary: Use statistics with not null where clauses
                 Key: IGNITE-14813
                 URL: https://issues.apache.org/jira/browse/IGNITE-14813
             Project: Ignite
          Issue Type: Improvement
          Components: sql
            Reporter: Alexander Belyak


Now we can use null counter only with "is null" where clauses, but we should use it with "not null" too. In queries like:
select * 
from employee 
where birth_date IS NOT NULL



--
This message was sent by Atlassian Jira
(v8.3.4#803005)