[IGNITE-13024] Calcite integration. Support and simplification of complex expressions in index conditions

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.15
• Component/s: sql
• Labels: calcite
• Release Note: SQL Calcite: Added complex expressions support to index scans
• Assignee: Aleksey Plekhanov
• Reporter: Roman Kondakov
• Created: 18/May/20 18:23
• Updated: 23/Feb/23 12:26
• Resolved: 19/Oct/22 10:18

Description

Current implementation supports only trivial expressions in index conditions, i.e. x=1. We need to support all evaluatable expressions (which not depends on input/table references) like x=?+10. Also we need to ensure that complex expressions in index filters are simplified (see RexSimplify).

Issue Links

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