Queries with question mark placeholders (?) not valid anymore
Open
Nobody has claimed this yet.
- Dominant language
- Go
- Stars
- 500
- Forks
- 29
- PR merge metrics
- No merged PRs in 30d
Description
Queries with (?) are not valid since updated version from 1.1.6 to 1.1.7/1.1.8, doesn't depend on go version
SELECT id FROM my_table WHERE id IN (?);
Getting ERROR: syntax error at or near ")"
Another example:
SELECT * FROM my_table WHERE id = ? AND user_id IN (?);
Getting ERROR: syntax error at or near "AND"
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 reproducing the two query examples with sqlvet versions 1.1.6, 1.1.7, and 1.1.8, then trace the SQL placeholder handling used by the analyzer. Done means question-mark placeholders in both queries are accepted or reported consistently without the shown syntax errors.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- go, sql
- Domain
- databases, tooling
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100