apla / node-clickhouse

Yandex ClickHouse driver for nodejs
MIT License
216 stars 50 forks source link

When the dynamic parameter of Uint64 exists in SQL, it returns null #84

Open allChangelove opened 2 years ago

allChangelove commented 2 years ago

When the dynamic parameter of Uint64 exists in SQL, it returns null

For example(JS):
const a = 2121212121212; (uint64,RPC for c++,The back-end interface is dynamically distributed to the front-end) const sql = select * from abc where value = ${a};

The execution result of this SQL is an empty array

But if I write a variable to death,For example: const sql = select * from abc where value = 2121212121212;

That's no problem,The table data can be obtained correctly

I don't know whether the SQL parsing failure is caused by the reference relationship,Because there is no difference between parameters and SQL strings