Description

Steps to reproduce

try (Statement s = connection.createStatement()) {
    try {
        s.executeUpdate("create table t (i int, primary key (i)) engine = MergeTree()");

        try (PreparedStatement p = connection.prepareStatement("delete from t where true")) {
            System.out.println(p.executeUpdate());
        }
    }
    finally {
        s.executeUpdate("drop table if exists t");
    }
}

The statement follows valid syntax and also works on the server and via JDBC:

• https://clickhouse.com/docs/sql-reference/statements/delete

Error Log or Exception StackTrace

12:06:05,741  WARN [SqlParser                     ] - SQL syntax error at line: 1, pos: 0, mismatched input 'delete' expecting {ALTER, ATTACH, CHECK, CREATE, DESC, DESCRIBE, DETACH, DROP, EXISTS, EXPLAIN, INSERT, KILL, OPTIMIZE, RENAME, REPLACE, SELECT, SET, SHOW, SYSTEM, TRUNCATE, USE, WATCH, WITH, GRANT, '('}
0

Expected Behaviour

No log message should be printed

Environment

• Client version: com.clickhouse:clickhouse-jdbc:0.9.2
• Language version: OpenJDK Runtime Environment Temurin-21.0.7+6 (build 21.0.7+6-LTS)
• OS: Microsoft Windows [Version 10.0.26100.4946]

ClickHouse Server

• ClickHouse Server version: 25.4.4.25