[CALCITE-5206] Parser allows MERGE with mismatched parentheses

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.31.0
• Assignee: Julian Hyde
• Reporter: Julian Hyde
• Created: 10/Jul/22 01:46
• Updated: 03/Aug/22 16:21
• Resolved: 11/Jul/22 20:16

Description

The SQL parser allows invalid MERGE statements with mismatched parentheses. For example, the following invalid statement is treated as valid but is missing a trailing ')':

merge into emps as e
using temps as t on e.empno = t.empno
when not matched
then insert (a, b) (values (1, 2);

And the following invalid statement is treated as valid but has an unmatched trailing ')':

merge into emps as e
using temps as t on e.empno = t.empno
when not matched
then insert (a, b) values (1, 2));

Issue Links

• relates to: CALCITE-5194 Cannot parse parenthesized UNION in subquery