Bogus SqlParser warning for valid NOT NULL constraint

[lukaseder]

Steps to reproduce

try (Statement s = connection.createStatement()) {
    try {
        s.executeUpdate("create table t (i int not null, primary key (i)) engine = MergeTree()");
    }
    finally {
        s.executeUpdate("drop table if exists t");
    }
}

Error Log or Exception StackTrace

12:27:36,155  WARN [SqlParser                     ] - SQL syntax error at line: 1, pos: 22, mismatched input 'not' expecting {',', ')'}

Expected Behaviour

No warnings, the syntax is valid:

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

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

[lukaseder]

The same happens when marking a column as nullable using that syntax:

create table t (
  i int, 
  j int null,
  primary key (i)
) engine = MergeTree()

[andrey-vasilyev]

I confirm I have the same issue

[chernser]

Verified in com.clickhouse.jdbc.internal.BaseSqlParserFacadeTest#testStatementsForResultSet