Skip to content

Error when using statements ending with ; #540

Open
@metalshanked

Description

@metalshanked

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!

Metadata

Metadata

Assignees

Labels

wontfixThis will not be worked on

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions