You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@spark.apache.org by "Mikhail Nikoliukin (Jira)" <ji...@apache.org> on 2024/09/10 13:47:00 UTC

[jira] [Commented] (SPARK-49398) Cache Table with Parameter markers returns wrong error

    [ https://issues.apache.org/jira/browse/SPARK-49398?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17880650#comment-17880650 ] 

Mikhail Nikoliukin commented on SPARK-49398:
--------------------------------------------

I am working on the issue

> 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
>              Labels: pull-request-available, starter
>
> 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: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org