[jira] [Created] (SPARK-27903) Improve parser error message for mismatched parentheses in expressions

["Yesheng Ma (JIRA)" <ji...@apache.org>]

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