Skip to content

Bogus SqlParser warning for valid ALTER TABLE .. MODIFY COMMENT syntax #2571

@lukaseder

Description

@lukaseder

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("alter table t modify comment 'comment'")) {
            System.out.println(p.executeUpdate());
        }
    }
    finally {
        s.executeUpdate("drop table if exists t");
    }
}

The query uses valid syntax and works well on the server:

Error Log or Exception StackTrace

12:19:00,841  WARN [SqlParser                     ] - SQL syntax error at line: 1, pos: 21, no viable alternative at input 'modifycomment'
0

Expected Behaviour

No warnings should be logged

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