find a bug in clickhouse-jdbc 0.6.0

[Young0516]

bug code : com.clickhouse.jdbc.internal.ClickHouseConnectionImpl#getTableColumns line 260

when I have a following table , this table contains a cloumn named '0'

in this code, it will run the sql:

this sql will get an error: Code: 59. DB::Exception: Illegal type Float64 of column 0 for filter. Must be UInt8 or Nullable(UInt8). (ILLEGAL_TYPE_OF_COLUMN_FOR_FILTER) (version 23.8.9.54 (official build))

when I remove 'where 0', it's ok

[chernser]

Good day, @Young0516! This is limitation according to the documentation https://clickhouse.com/docs/en/sql-reference/statements/select/where Actually client doesn't validate this and Code: 59 is what returned by server (repo https://github.com/ClickHouse/ClickHouse).

[Young0516]

@chernser Hi chernser thanks for your response, I think the rootcause is that there is a column named '0', I may need to report the bug to server (repo https://github.com/ClickHouse/ClickHouse).