[SPARK-47905] ANSI Mode: Trim binary values shall result binary type instead of string type

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 4.0.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Kent Yao
• Created: 19/Apr/24 03:20
• Updated: 30/Apr/24 01:01

Description

```

<trim function> when applied to binary strings is identical in syntax (apart from the default <trim character>) and semantics to the corresponding operation on character strings except that the returned value is a binary string.

```

Issue Links

• relates to: SPARK-44444 Use ANSI SQL mode by default