[SPARK-48929] View fails with internal error after upgrade causes expected syntax error.

• 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: Serge Rielau
• Reporter: Serge Rielau
• Shepherd: Gengliang Wang
• Created: 17/Jul/24 18:02
• Updated: 22/Jul/24 18:24
• Resolved: 22/Jul/24 18:24

Description

On older Spark:
CREATE VIEW v AS SELECT 1 ! IN (2);
SEELCT * FROM v;
=> true
Upgrade to Spark 4
SELECT * FROM v;
Internal error 

This makes it hard to debug the problem.
Rather than assuming that failure to parse a view text is an internal error we should assume something like upgrade broke it and expose the actual error

Issue Links

• links to: GitHub Pull Request #47405