Extraneous input 'ip' expecting

[z0mb1ek]

Hi, i use latest client 0.9.1 and get trouble with word ip, is it reserved? I cannot find

val sqlParser: SqlParser = SqlParser()
println(sqlParser.parsePreparedStatement("CREATE TABLE IF NOT EXISTS statistics.vast_event_v2\n" +
            "(\n" +
            "    ip             UInt32\n" +
            ") ENGINE = ReplacingMergeTree()"))

and get error:

[WARN ] 2025-08-07 04:09:46,740 com.clickhouse.jdbc.internal.SqlParser - SQL syntax error at line: 3, pos: 4, extraneous input 'ip' expecting {AFTER, ALIAS, ALL, ALTER, AND, ANTI, ANY, ARRAY, AS, ASCENDING, ASOF, AST, ASYNC, ATTACH, BETWEEN, BOTH, BY, CASE, CAST, CHECK, CLEAR, CLUSTER, CODEC, COLLATE, COLUMN, COMMENT, CONSTRAINT, CREATE, CROSS, CUBE, CURRENT, DATABASE, DATABASES, DATE, DAY, DEDUPLICATE, DEFAULT, DELAY, DELETE, DESC, DESCENDING, DESCRIBE, DETACH, DICTIONARIES, DICTIONARY, DISK, DISTINCT, DISTRIBUTED, DROP, ELSE, END, ENGINE, EVENTS, EXISTS, EXPLAIN, EXPRESSION, EXTRACT, FETCHES, FINAL, FIRST, FLUSH, FOLLOWING, FOR, FORMAT, FREEZE, FROM, FULL, FUNCTION, GLOBAL, GRANULARITY, GROUP, HAVING, HIERARCHICAL, HOUR, ID, IF, ILIKE, IN, INDEX, INJECTIVE, INNER, INSERT, INTERVAL, INTO, IS, IS_OBJECT_ID, JOIN, KEY, KILL, LAST, LAYOUT, LEADING, LEFT, LIFETIME, LIKE, LIMIT, LIVE, LOCAL, LOGS, MATERIALIZE, MATERIALIZED, MAX, MERGES, MIN, MINUTE, MODIFY, MONTH, MOVE, MUTATION, NAME, NO, NOT, NULL_SQL, NULLS, OFFSET, ON, OPTIMIZE, OR, ORDER, OUTER, OUTFILE, OVER, PARTITION, POPULATE, PRECEDING, PREWHERE, PRIMARY, PROJECTION, QUARTER, RANGE, RELOAD, REMOVE, RENAME, REPLACE, REPLICA, REPLICATED, RIGHT, ROLLUP, ROW, ROWS, SAMPLE, SECOND, SELECT, SEMI, SENDS, SET, SETTINGS, SHOW, SOURCE, START, STOP, SUBSTRING, SYNC, SYNTAX, SYSTEM, TABLE, TABLES, TEMPORARY, TEST, THEN, TIES, TIMEOUT, TIMESTAMP, TO, TOP, TOTALS, TRAILING, TRIM, TRUNCATE, TTL, TYPE, UNBOUNDED, UNION, UPDATE, USE, USER, USING, UUID, VALUES, VIEW, VOLUME, WATCH, WEEK, WHEN, WHERE, WINDOW, WITH, YEAR, GRANT, 'false', 'true', IDENTIFIER}
[WARN ] 2025-08-07 04:09:46,741 com.clickhouse.jdbc.internal.SqlParser - SQL syntax error at line: 4, pos: 0, no viable alternative at input 'UInt32)'

[chernser]

Good day, @z0mb1ek !
Thank you for reporting!

• As I see it is just warning. As there are no parameters in the statement it should work fine and you can ignore them.
• Simple statement is better choice for DDL statements.

[victor-tsykanov]

The same issue with "url" word.
This is actually a problem when using query with parameters because it fails to parse parameters from the query.
The workaround I've found is to put these words in double quotes in the query.

[chernser]

Thank you, @victor-tsykanov !
It will be fixed in 0.9.3 release.

Another issue with the statement is that db named statistics what is a keyword and should be known to parser otherwise it doesn't match identifier rule.