[IGNITE-16507] Calcite engine. Redundant sort node when rewriting index scan on index rebuild

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Labels: calcite calcite2-required calcite3-required
• Assignee: Unassigned
• Reporter: Aleksey Plekhanov
• Created: 09/Feb/22 12:22
• Updated: 09/Feb/22 12:23

Description

When the query plan has an index scan, but the index is rebuilding we rewrite this scan to the chain of table scan/sort/spool/project nodes (see IGNITE-16111). In some cases sort node is redundant, but still created, for example, when index scan is used only for filtering:

SELECT * FROM emp WHERE dep_id = 10

Issue Links

• is part of: IGNITE-12248 Apache Calcite based query execution engine
• is related to: IGNITE-16111 Calcite engine. Fallback to table scan if index is absent on some nodes