[SPARK-38318] regression when replacing a dataset view

• Type: Task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.2.0, 3.2.1, 3.3.0
• Fix Version/s: 3.3.0, 3.2.2
• Component/s: SQL
• Assignee: Linhong Liu
• Reporter: Linhong Liu
• Created: 24/Feb/22 17:09
• Updated: 24/May/23 18:19
• Resolved: 01/Mar/22 07:11

Description

The below use case works well in 3.1 but failed in 3.2 and master.

sql("select 1").createOrReplaceTempView("v")
sql("select * from v").createOrReplaceTempView("v")
// in 3.1 it works well, and select will output 1
// in 3.2 it failed with error: "AnalysisException: Recursive view v detected (cycle: v -> v)"

Issue Links

• is duplicated by: SPARK-37690 Recursive view `df` detected (cycle: `df` -> `df`)
• links to: [Github] Pull Request #35653 (linhongliu-db)
• links to: [Github] Pull Request #35653 (linhongliu-db)