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

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

Open allChangelove opened this issue 3 years ago • 0 comments

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

allChangelove avatar Jul 15 '22 05:07 allChangelove