[SPARK-46029] Escape the single quote, _ and % for DS V2 pushdown

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.4.0, 3.5.0, 4.0.0
• Fix Version/s: 4.0.0, 3.5.1
• Component/s: SQL
• Labels: correctness pull-request-available
• Assignee: Jiaan Geng
• Reporter: Jiaan Geng
• Created: 21/Nov/23 08:05
• Updated: 01/Dec/23 07:00
• Resolved: 29/Nov/23 00:38

Description

Spark supports push down startsWith, endWith and contains to JDBC database with DS V2 pushdown.
But the V2ExpressionSQLBuilder didn't escape the single quote, _ and %, it can cause unexpected result.

Issue Links

• links to: GitHub Pull Request #43801
• links to: GitHub Pull Request #44066
• links to: GitHub Pull Request #44089