Ankit Siva created CALCITE-5835:
-----------------------------------
Summary: SqlParser.parseQuery() successfully parses DML and DDL
statements without throwing a SqlParseException
Key: CALCITE-5835
URL: https://issues.apache.org/jira/browse/CALCITE-5835
Project: Calcite
Issue Type: Bug
Components: core
Affects Versions: 1.34.0
Reporter: Ankit Siva
I've set up a parser as follows:
```
val config= SqlParser.config()
.withConformance(SqlConformanceEnum.BABEL)
.withQuoting(Quoting.DOUBLE_QUOTE)
.withQuotedCasing(Casing.TO_LOWER)
.withUnquotedCasing(Casing.TO_LOWER)
.withCaseSensitive(false)
val parser = SqlParser.create(sql, config)
parser.parseQuery()
```
I am parsing the following statements:
```
1.
INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode,
Country)
VALUES ('Cardinal', 'Tom B. Erichsen', 'Skagen 21', 'Stavanger', '4006',
'Norway')
2.
INSERT INTO emps (emp_id , emp_name , emp_salary)
SELECT employee_id , last_name , salary
FROM employees
WHERE department_id = 50
3.
UPDATE employees
SET salary = 5000
WHERE employee_id = 100
4.
DELETE FROM employees
WHERE department_id = (
SELECT department_id FROM departments
WHERE department_name = 'Sales'
)
5.
MERGE INTO customers_backup bkup
USING customers cust
ON (bkup.cust_id = cust.cust_id)
WHEN MATCHED THEN
UPDATE SET
bkup.cust_name = cust.cust_name ,
bkup.cust_surfing_package = cust.cust_surfing_package
WHEN NOT MATCHED THEN
INSERT VALUES(cust.cust_id , cust.cust_name , cust.cust_surfing_package)
```
Parsing any of these queries does not raise a `SqlParseException`.
Additionally, these return nodes that are not of type `SqlSelect` or
`SqlBinaryOperator`. This conflicts with the expectation of the method and the
contract declared in the
[javadoc](https://calcite.apache.org/javadocAggregate/org/apache/calcite/sql/parser/SqlParser.html#parseQuery())
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
