[SPARK-49398] Cache Table with Parameter markers returns wrong error

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 4.0.0
• Fix Version/s: 4.0.0
• Component/s: SQL
• Labels: pull-request-available starter
• Assignee: Mikhail Nikoliukin
• Reporter: Mihailo Milosevic
• Created: 26/Aug/24 22:23
• Updated: 11/Sep/24 08:53
• Resolved: 11/Sep/24 08:53

Description

When investigating the OSS structure of code it was found that `CacheTableAsSelect` when used with parameter markers in the select part of the query fails with `UNBOUND_SQL_PARAMETER` even though logically it should fail with `UNSUPPORTED_FEATURE.PARAMETER_MARKER_IN_UNEXPECTED_STATEMENT`. The reason for the second error is that `CacheTableAsSelect` creates a temporary view which should follow rules for parameter markers as views does.

Issue Links

• links to: GitHub Pull Request #48055