[SPARK-50322] Cannot resolve parameterized identifier in a sub-query

• 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: Max Gekk
• Reporter: Max Gekk
• Created: 14/Nov/24 19:33
• Updated: 15/Nov/24 15:42
• Resolved: 15/Nov/24 12:14

Description

The example below portraits the issue:

Unable to find source-code formatter for language: sq. Available languages are: actionscript, ada, applescript, bash, c, c#, c++, cpp, css, erlang, go, groovy, haskell, html, java, javascript, js, json, lua, none, nyan, objc, perl, php, python, r, rainbow, ruby, scala, sh, sql, swift, visualbasic, xml, yaml

create table tt1(c1 int);
insert into tt1 values (1);
execute immediate 'with v1 as (select * from tt1 where 1 = (Select * from identifier(:tab))) select * from v1' using 'tt1' as tab;
[UNBOUND_SQL_PARAMETER] Found the unbound parameter: tab. 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 66;
'Project [*]
+- 'SubqueryAlias v1
   +- 'SubqueryAlias v1
      +- 'Project [*]
         +- 'Filter (1 = scalar-subquery#10 [])
            :  +- 'Project [*]
            :     +- 'PlanWithUnresolvedIdentifier namedparameter(tab), org.apache.spark.sql.catalyst.parser.AstBuilder$$Lambda$3404/0x000000f802380000@45ec7633
            +- SubqueryAlias spark_catalog.default.tt1
               +- Relation spark_catalog.default.tt1[c1#4] parquet

Issue Links

• links to: GitHub Pull Request #48847