[
https://issues.apache.org/jira/browse/SPARK-52870?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dusan Tisma updated SPARK-52870:
--------------------------------
Description:
*Example 1:*
{{BEGIN}}
{{ FOR SELECT 1 DO}}
{{ SELECT 1;}}
{{ END FOR;}}
{{END}}
Error:
{{[PARSE_SYNTAX_ERROR] Syntax error at or near '1'. SQLSTATE: 42601}}
*Example 2:*
Table tbl has a column 'Start Date'
{{BEGIN}}
{{ FOR r AS SELECT * FROM tbl DO}}
{{ SELECT 1;}}
{{ END FOR;}}
{{END}}
Error:
[PARSE_SYNTAX_ERROR] Syntax error at or near 'Date': extra input 'Date'.
SQLSTATE: 42601
was:
Example 1:
{{BEGIN}}
{{ FOR SELECT 1 DO}}
{{ SELECT 1;}}
{{ END FOR;}}
{{END}}
Error:
{{[PARSE_SYNTAX_ERROR] Syntax error at or near '1'. SQLSTATE: 42601}}
Example 2:
Table tbl has a column 'Start Date'
{{BEGIN}}
{{ FOR r AS SELECT * FROM tbl DO}}
{{ SELECT 1;}}
{{ END FOR;}}
{{END}}
Error:
[PARSE_SYNTAX_ERROR] Syntax error at or near 'Date': extra input 'Date'.
SQLSTATE: 42601
> FOR statement errors when referenced columns have whitespace, or are int
> literals
> ---------------------------------------------------------------------------------
>
> Key: SPARK-52870
> URL: https://issues.apache.org/jira/browse/SPARK-52870
> Project: Spark
> Issue Type: Sub-task
> Components: Spark Core, SQL
> Affects Versions: 4.0.0
> Reporter: Dusan Tisma
> Priority: Major
>
> *Example 1:*
> {{BEGIN}}
> {{ FOR SELECT 1 DO}}
> {{ SELECT 1;}}
> {{ END FOR;}}
> {{END}}
> Error:
> {{[PARSE_SYNTAX_ERROR] Syntax error at or near '1'. SQLSTATE: 42601}}
>
> *Example 2:*
> Table tbl has a column 'Start Date'
> {{BEGIN}}
> {{ FOR r AS SELECT * FROM tbl DO}}
> {{ SELECT 1;}}
> {{ END FOR;}}
> {{END}}
> Error:
> [PARSE_SYNTAX_ERROR] Syntax error at or near 'Date': extra input 'Date'.
> SQLSTATE: 42601
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
