[SPARK-44066] Support positional parameters in parameterized query

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.5.0
• Fix Version/s: 3.5.0
• Component/s: SQL
• Assignee: Max Gekk
• Reporter: Max Gekk
• Created: 15/Jun/23 08:13
• Updated: 22/Jun/23 07:30
• Resolved: 22/Jun/23 06:40

Description

As a follow-up to the parameterized query we added recently, we’d like to support positional parameters. This is part of the SQL standard and JDBC/ODBC protocol.

Example: update COFFEES set TOTAL = TOTAL + ? where COF_NAME = ?

Note that positional and named param marker cannot be used in the same query.

Issue Links

• blocks: SPARK-44068 Support positional parameters in Scala connect client
• is cloned by: SPARK-44140 Support positional parameters in PySpark sql()
• links to: [Github] Pull Request #41568 (MaxGekk)
• links to: [Github] Pull Request #41568 (MaxGekk)