Open
Description
Expected behavior
Ideally, SQL statements with or without ";" should work
Actual behavior
SQL statements ending with ";" are passthrough to Trino and fail with the below error.
Other JDBC Driver clients seem to remove the ";" and send to Trino
Steps To Reproduce
SELECT * FROM "catalog"."schema".table LIMIT 10;
io.trino.sql.parser.ParsingException: line 1:68: mismatched input ';'. Expecting: <EOF>
at io.trino.sql.parser.ErrorHandler.syntaxError(ErrorHandler.java:108)
at org.antlr.v4.runtime.ProxyErrorListener.syntaxError(ProxyErrorListener.java:41)
at org.antlr.v4.runtime.Parser.notifyErrorListeners(Parser.java:544)
at org.antlr.v4.runtime.DefaultErrorStrategy.reportInputMismatch(DefaultErrorStrategy.java:327)
at org.antlr.v4.runtime.DefaultErrorStrategy.reportError(DefaultErrorStrategy.java:139)
at io.trino.grammar.sql.SqlBaseParser.singleStatement(SqlBaseParser.java:352)
Log output
No response
Operating System
debian bookworm
Trino Python client version
0.318.0
Trino Server version
472
Python version
3.10.2
Are you willing to submit PR?
- Yes I am willing to submit a PR!