[SPARK-47939] Parameterized queries fail for DESCRIBE & EXPLAIN w/ UNBOUND_SQL_PARAMETER error

• Type: Bug
• 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: Vladimir Golubev
• Reporter: Vladimir Golubev
• Created: 22/Apr/24 13:27
• Updated: 29/Apr/24 09:01
• Resolved: 29/Apr/24 09:01

Description

Succeeds: scala> spark.sql("select ?", Array(1)).show();

Fails: spark.sql("describe select ?", Array(1)).show();

Fails: spark.sql("explain select ?", Array(1)).show();

Failures are of the form:

org.apache.spark.sql.catalyst.ExtendedAnalysisException: [UNBOUND_SQL_PARAMETER] Found the unbound parameter: _16. Please, fix `args` and provide a mapping of the parameter to either a SQL literal or collection constructor functions such as `map()`, `array()`, `struct()`. SQLSTATE: 42P02; line 1 pos 16; 'Project [unresolvedalias(posparameter(16))] +- OneRowRelation

Issue Links

• links to: GitHub Pull Request #46209