Skip to content

Bogus SqlParser warning for valid DELETE statement #2569

@lukaseder

Description

@lukaseder

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:

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

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions