a semicolon in query is not handled correctly

[pkit]

client = clickhouse_connect.create_client()
result = client.query("SELECT 1;").result_set
print(result)

clickhouse_connect.driver.exceptions.DatabaseError: :HTTPDriver for http://localhost:8123 returned response code 400)
 Code: 62. DB::Exception: Syntax error (Multi-statements are not allowed): failed at position 9 (end of query) (line 1, col 9): ;
 FORMAT Native. . (SYNTAX_ERROR) (version 23.8.1.2992 (official build))

[genzgd]

That's a message returned by ClickHouse itself. Multiple SQL statements are not allowed over the HTTP interface, and semi-colons at the end are therefore rejected.

[pkit]

Not really:

$ curl --data-binary 'SELECT 1;' http://localhost:8123/
1

[genzgd]

clickhouse-connect automatically adds a Format Native to the end of queries, so in theory the driver could strip off trailing semi-colons, but that seems fragile.