[IGNITE-13022] Calcite integration. Merge index conditions for the same field.

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 2.15
• Component/s: sql
• Labels: calcite
• Release Note: SQL Calcite: Added optimization to merge index conditions for the same field
• Ignite Flags: Release Notes Required
• Assignee: Aleksey Plekhanov
• Reporter: Roman Kondakov
• Created: 18/May/20 17:28
• Updated: 20/Apr/23 11:45
• Resolved: 13/Oct/22 14:51

Description

Index scans should be able to merge index conditions. For example query

SELECT * FROM tbl WHERE a<5 AND a<10

should be reduced to

 

SELECT * FROM tbl WHERE a<5

Parameters should be handled in a more tricky way:

SELECT * FROM tbl WHERE a<?1 AND a<?2

can be rewritten as

SELECT * FROM tbl WHERE a<MIN(?1, ?2)

where the expression MIN(?1, ?2) should be evaluated right before the execution when parameters are known.

 

 

Issue Links

• is part of: IGNITE-12248 Apache Calcite based query execution engine
• links to: AI3 GitHub Pull Request #1583
• links to: GitHub Pull Request #1583
• links to: GitHub Pull Request #10306