[SPARK-48273] Late rewrite of PlanWithUnresolvedIdentifier - ASF JIRA

XML

Word

Printable

JSON

Details

Type: Bug
Status: Resolved
Priority: Major
Resolution: Fixed
Affects Version/s: 4.0.0
Fix Version/s: 4.0.0, 3.5.2
Component/s: SQL
Labels:
- pull-request-available

Description

PlanWithUnresolvedIdentifier is rewritten later in analysis which causes rules like
SubstituteUnresolvedOrdinals to miss the new plan. This causes following queries to fail:

create temporary view identifier('v1') as (select my_col from (values (1), (2), (1) as (my_col)) group by 1);
--
cache table identifier('t1') as (select my_col from (values (1), (2), (1) as (my_col)) group by 1); 
--
create table identifier('t2') as (select my_col from (values (1), (2), (1) 
as (my_col)) group by 1);
insert into identifier('t2') select my_col from (values (3) as (my_col)) group by 1;