[SPARK-48472] Enable reflect expressions with collated strings

• Type: Sub-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
• Assignee: Mihailo Milosevic
• Reporter: Mihailo Milosevic
• Created: 30/May/24 07:21
• Updated: 19/Jun/24 08:24
• Resolved: 19/Jun/24 08:24

Description

As a movement to collated world, we need to make sure all expressions are supported by appropriate collations. Using expression walker testing `CallMethodViaReflection` was found to be erroneous. This expression is used as a replacement for all reflection methods and needs to be improved. This ticket needs to update methods of this expression. Relevant code could be found in these files: `CallMethodViaReflection.scala`, `TypeCoercion.scala`, `AnsiTypeCoercion.scala`, `CollationTypeCasts.scala`, and for testing `Collation*Suite.scala` files.

Issue Links

• links to: GitHub Pull Request #46991