[SPARK-47033] EXECUTE IMMEDIATE USING does not recognize session variable names

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.0.0
• Fix Version/s: 4.0.0
• Component/s: Spark Core
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: Serge Rielau
• Shepherd: Wenchen Fan
• Created: 13/Feb/24 18:54
• Updated: 05/Mar/24 18:16
• Resolved: 05/Mar/24 18:16

Description

DECLARE parm = 'Hello';

EXECUTE IMMEDIATE 'SELECT :parm' USING parm;
[ALL_PARAMETERS_MUST_BE_NAMED] Using name parameterized queries requires all parameters to be named. Parameters missing names: "parm". SQLSTATE: 07001

EXECUTE IMMEDIATE 'SELECT :parm' USING parm AS parm;
Hello

variables are like column references, they act as their own aliases and thus should not be required to be named to associate with a named parameter with the same name.

Note that unlike for pySpark this should be case insensitive (haven't verified).

Issue Links

• links to: GitHub Pull Request #45293