[
https://issues.apache.org/jira/browse/SPARK-49398?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mihailo Milosevic updated SPARK-49398:
--------------------------------------
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.
> Cache Table with Parameter markers returns wrong error
> ------------------------------------------------------
>
> Key: SPARK-49398
> URL: https://issues.apache.org/jira/browse/SPARK-49398
> Project: Spark
> Issue Type: Improvement
> Components: SQL
> Affects Versions: 4.0.0
> Reporter: Mihailo Milosevic
> Priority: Minor
>
> 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.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
