clickhouse-java icon indicating copy to clipboard operation
clickhouse-java copied to clipboard

find a bug in clickhouse-jdbc 0.6.0

Open Young0516 opened this issue 9 months ago • 1 comments

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

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

image

in this code, it will run the sql:
image

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

Young0516 avatar May 20 '24 12:05 Young0516