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)