Ruben Q L created CALCITE-4195: ---------------------------------- Summary: Cast from character to character with a different collator is 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 Fix For: 1.26.0
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. -- This message was sent by Atlassian Jira (v8.3.4#803005)