[SPARK-45398] Include `ESCAPE` to `sql()` of `Like`

• Type: Improvement
• 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: Max Gekk
• Reporter: Max Gekk
• Created: 03/Oct/23 13:02
• Updated: 04/Oct/23 08:35
• Resolved: 04/Oct/23 08:35

Description

Fix the `sql()` method of the `Like` expression and append the `ESCAPE` closure. That should become consistent to `toString` and fix the issue:

spark-sql (default)> create temp view tbl as (SELECT 'a|_' like 'a||_' escape '|', 'a|_' like 'a||_' escape 'a');
[COLUMN_ALREADY_EXISTS] The column `a|_ like a||_` already exists. Consider to choose another name or rename the existing column.

Issue Links

• links to: GitHub Pull Request #43196