You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Thomas Graves (Jira)" <ji...@apache.org> on 2020/03/03 15:58:00 UTC

[jira] [Resolved] (SPARK-30049) SQL fails to parse when comment contains an unmatched quote character

     [ https://issues.apache.org/jira/browse/SPARK-30049?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Thomas Graves resolved SPARK-30049.
-----------------------------------
    Fix Version/s: 3.1.0
                   3.0.0
       Resolution: Fixed

> SQL fails to parse when comment contains an unmatched quote character
> ---------------------------------------------------------------------
>
>                 Key: SPARK-30049
>                 URL: https://issues.apache.org/jira/browse/SPARK-30049
>             Project: Spark
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 3.0.0
>            Reporter: Jason Darrell Lowe
>            Priority: Major
>             Fix For: 3.0.0, 3.1.0
>
>         Attachments: Screen Shot 2019-12-18 at 9.26.29 AM.png
>
>
> A SQL statement that contains a comment with an unmatched quote character can lead to a parse error.  These queries parsed correctly in older versions of Spark.  For example, here's an excerpt from an interactive spark-sql session on a recent Spark-3.0.0-SNAPSHOT build (commit e23c135e568d4401a5659bc1b5ae8fc8bf147693):
> {noformat}
> spark-sql> SELECT 1 -- someone's comment here
>          > ;
> Error in query: 
> extraneous input ';' expecting <EOF>(line 2, pos 0)
> == SQL ==
> SELECT 1 -- someone's comment here
> ;
> ^^^
> {noformat}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org