search

TimonKK / clickhouse

NodeJS client for ClickHouse
Apache License 2.0
221 stars 122 forks source link

can not insert with lower case of 'insert into ...' query. Error: insert query wasnt parsed field list after TABLE_NAME #130

Closed SEA99 closed 2 years ago

SEA99 commented 2 years ago

query: insert into test2 ( EXCEPT(id,version,logo),id,version,logo) select EXCEPT(id,version,logo) APPLY(x->argMax(x,version)), id, max(version)+1,{logo:String} from test2 where id={id:UUID} group by id

exception: Error: insert query wasnt parsed field list after TABLE_NAME

SEA99 commented 2 years ago

problem was in lower case of "insert into"

SEA99 commented 2 years ago

solved in https://github.com/TimonKK/clickhouse/pull/134