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

Array in bind variables not working #20

Open
simpleseeker opened this issue Jan 3, 2022 · 0 comments
Open

Array in bind variables not working #20

simpleseeker opened this issue Jan 3, 2022 · 0 comments

Comments

@simpleseeker
Copy link

I want to avoid doing something like :
SELECT count(*) FROM X WHERE ARRAY_CONTAINS(primary_key::variant, SPLIT(:1, ';'))
I would prefer to do something like:
SELECT count(*) FROM X WHERE primary_key in : 1
The issue seems to be array can not be passed in . If I try to execute the following,
snowflake.createStatement({ sqlText, [ ['95844590 20210404', '80291453 20210105'], 'test' ] });, I get a Bind variable :1 not set. error.

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

1 participant