-
Type:
Sub-task
-
Status: Open
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: 3.1.0
-
Fix Version/s: None
-
Component/s: SQL
-
Labels:None
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
SELECT ((x + y) * z FROM t;
is
mismatched input 'FROM' expecting ','(line 1, pos 20)
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
mismatched parentheses for expression 'SELECT ((x + y) * z FROM t;'(line 1, pos 20)
- links to