[ https://issues.apache.org/jira/browse/IGNITE-16414?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17487071#comment-17487071 ]
Aleksey Plekhanov commented on IGNITE-16414: -------------------------------------------- [~zstan], [~tledkov-gridgain], [~ivandasch], [~korlov], can you please review the patch? > 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: 10m > 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)