Yesheng Ma created SPARK-27903:
----------------------------------

             Summary: Improve parser error message for mismatched parentheses 
in expressions
                 Key: SPARK-27903
                 URL: https://issues.apache.org/jira/browse/SPARK-27903
             Project: Spark
          Issue Type: Sub-task
          Components: SQL
    Affects Versions: 3.0.0
            Reporter: Yesheng Ma


When parentheses are mismatched in expressions in queries, the error message is 
confusing. This is especially true for large queries, where mismatched parens 
are tedious for human to figure out.

For example, the error message for 
{code:sql}
SELECT ((x + y) * z FROM t;
{code}
is
{code:java}
mismatched input 'FROM' expecting ','(line 1, pos 20)
{code}

One possible way to fix is to explicitly capture such kind of mismatched parens 
in a grammar rule and print user-friendly error message such as
{code:java}
mismatched parentheses for expression 'SELECT ((x + y) * z FROM t;'(line 1, pos 
20)
{code}




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

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

Reply via email to