[SPARK-47422] Support collated strings in array operations

• Type: Task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.0.0
• Fix Version/s: 4.0.0
• Component/s: SQL
• Labels: pull-request-available
• Target Version/s: 4.0.0
• Epic Link: Collation support
• Assignee: Nikola Mandic
• Reporter: Nikola Mandic
• Created: 15/Mar/24 15:46
• Updated: 19/Mar/24 05:00
• Resolved: 19/Mar/24 05:00

Description

Collations need to be properly supported in following array operations but currently yield unexpected results: ArraysOverlap, ArrayDistinct, ArrayUnion, ArrayIntersect, ArrayExcept. Example query:

select array_contains(array('aaa' collate utf8_binary_lcase), 'AAA' collate utf8_binary_lcase)

We would expect the result of query to be true.

Issue Links

• links to: GitHub Pull Request #45563