[jira] [Created] (IGNITE-13022) Calcite integration. Merge index conditions for the same field.

["Roman Kondakov (Jira)" <ji...@apache.org>]

Roman Kondakov created IGNITE-13022:
---------------------------------------

             Summary: Calcite integration. Merge index conditions for the same field.
                 Key: IGNITE-13022
                 URL: https://issues.apache.org/jira/browse/IGNITE-13022
             Project: Ignite
          Issue Type: Improvement
          Components: sql
            Reporter: Roman Kondakov


Index scans should be able to merge index conditions. For example query
{code:java}
SELECT * FROM tbl WHERE a<5 AND a<10
{code}
should be reduced to

 
{code:java}
SELECT * FROM tbl WHERE a<5
{code}
Parameters should be handled in a more tricky way:
{code:java}
SELECT * FROM tbl WHERE a<?1 AND a<?2
{code}
can be rewritten as
{code:java}
SELECT * FROM tbl WHERE a<MIN(?1, ?2){code}
where the expression {{MIN(?1, ?2)}} should be evaluated right before the execution when parameters are known.

 

 



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