[
https://issues.apache.org/jira/browse/CALCITE-4195?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17186323#comment-17186323
]
Ruben Q L commented on CALCITE-4195:
------------------------------------
Fixed via
https://github.com/apache/calcite/commit/425f170a9b0589cb7f693e93cbcd044e9ab98c75
> Cast between types with different collators must be evaluated as not monotonic
> ------------------------------------------------------------------------------
>
> Key: CALCITE-4195
> URL: https://issues.apache.org/jira/browse/CALCITE-4195
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.24.0
> Reporter: Ruben Q L
> Assignee: Ruben Q L
> Priority: Minor
> Labels: pull-request-available
> Fix For: 1.26.0
>
> Time Spent: 20m
> Remaining Estimate: 0h
>
> Problem related to the feature CALCITE-3951.
> A cast operation from a character type to another character type that has a
> different collator must be evaluated as not monotonic. Currently this is not
> the case.
> This has an impact e.g. in SortProjectTransposeRule, since we can incorrectly
> transpose a sort after a projection than contains such a cast, and we end up
> with a plan that will return a different result than the original one (it is
> not the same casting and then sorting; than sorting and then casting).
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
