Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
allChangelove opened this issue Jul 15, 2022 · 1 comment
Open

Comments

@allChangelove
Copy link

allChangelove commented Jul 15, 2022

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

@SEA99
Copy link
Contributor

SEA99 commented Aug 28, 2022

In JS Big values of UINT64 can not be stored in number. There are 64 bits in double float including exponent part.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants