tree 84b1cb93efa74cc86f60eafeb3305f91eba726c3
parent c8c2492041782b9be7f10647191dcd0d5f6a5a8a
author Milan Dankovic <milan.dankovic@databricks.com> 1714487336 +0800
committer Wenchen Fan <wenchen@databricks.com> 1714487336 +0800

[SPARK-47359][SQL] Support TRANSLATE function to work with collated strings

### What changes were proposed in this pull request?
Extend built-in string functions to support non-binary, non-lowercase collation for: `translate`

### Why are the changes needed?
Update collation support for built-in string functions in Spark.

### Does this PR introduce _any_ user-facing change?
Yes, users should now be able to use COLLATE within arguments for built-in string function TRANSLATE in Spark SQL queries, using non-binary collations such as UNICODE_CI.

### How was this patch tested?
Unit tests for queries using StringTranslate (CollationStringExpressionsSuite.scala).

### Was this patch authored or co-authored using generative AI tooling?
No

Closes #45820 from miland-db/miland-db/string-translate.

Authored-by: Milan Dankovic <milan.dankovic@databricks.com>
Signed-off-by: Wenchen Fan <wenchen@databricks.com>