[
https://issues.apache.org/jira/browse/IGNITE-16414?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17488105#comment-17488105
]
Aleksey Plekhanov commented on IGNITE-16414:
--------------------------------------------
[~zstan] thanks for the review! Merged to sql-calcite branch.
> Calcite engine. Sorted index spool produces wrong collation
> -----------------------------------------------------------
>
> Key: IGNITE-16414
> URL: https://issues.apache.org/jira/browse/IGNITE-16414
> Project: Ignite
> Issue Type: Bug
> Reporter: Aleksey Plekhanov
> Assignee: Aleksey Plekhanov
> Priority: Major
> Labels: calcite2-required, calcite3-required
> Time Spent: 50m
> Remaining Estimate: 0h
>
> The sorted index spool does not take into account input collation directions
> and null ordering. When generating collation based on conditions, default
> direction and null ordering are used. This leads to wrong planning in case of
> not default null ordering (additional sort node inserted even if we iterating
> by index with required collation) and wrong index conditions usage in case of
> descending direction (upper and lower bound are inverted for DESC direction).
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
