prepared statement having multiple in clause
Open
Nobody has claimed this yet.
- Dominant language
- JavaScript
- Stars
- 322
- Forks
- 99
- PR merge metrics
- No merged PRs in 30d
Description
I have array object A1= [,1,2,3,4,5,6] and A2=[6,8,9,7,4]
How can I pass to prepared statement having multiple in clause . With single In clause its working .
In multiple in clause how do I can pass multiple array object , I tried passing parameter as [ A1,A2] but failed .
SELECT * FROM "schema"."table" WHERE "c1" IN (?) AND "c2" IN (?)"
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by reviewing node-hdb's prepared statement handling for the shown SQL query with two IN clauses and compare it with the single-IN case described in the issue. Done means determining how multiple array parameters should be passed, or documenting that this form is unsupported and what the supported usage is.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- javascript, sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100