[SPARK-48430] Fix map value extraction when map contains collated strings

• 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
• Epic Link: Collation support
• Assignee: Nikola Mandic
• Reporter: Nikola Mandic
• Created: 27/May/24 11:45
• Updated: 31/May/24 16:23
• Resolved: 31/May/24 16:23

Description

Following queries return unexpected results:

select collation(map('a', 'b' collate utf8_binary_lcase)['a']);
select collation(element_at(map('a', 'b' collate utf8_binary_lcase), 'a'));

Both return UTF8_BINARY instead of UTF8_BINARY_LCASE.

Issue Links

• links to: GitHub Pull Request #46758