Julian Hyde created CALCITE-5206: ------------------------------------ Summary: Parser allows MERGE with mismatched parentheses Key: CALCITE-5206 URL: https://issues.apache.org/jira/browse/CALCITE-5206 Project: Calcite Issue Type: Bug Reporter: Julian Hyde
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 ')': {code} merge into emps as e using temps as t on e.empno = t.empno when not matched then insert (a, b) (values (1, 2); {code} And the following invalid statement is treated as valid but has an unmatched trailing ')': {code} merge into emps as e using temps as t on e.empno = t.empno when not matched then insert (a, b) values (1, 2)); {code} -- This message was sent by Atlassian Jira (v8.20.10#820010)