Support NOT BETWEEN
Open
- Dominant language
- JavaScript
- Stars
- 385
- Forks
- 117
- PR merge metrics
- No merged PRs in 30d
Description
node-sqlparser supports `BETWEEN` but doesn't support `NOT BETWEEN`
``` sql
SELECT * WHERE salary not between '40000' and '150000'
```
yields `Expected "CONTAINS", "IN", "LIKE" or WHITE_SPACE but "b" found.`
If this isn't expected in standard SQL, feel free to disregard, but I assume it is
Contributor guide
No contributing guide indexed for this repository
Research direction
Start by reproducing the provided SELECT query in nquery and trace the SQL parser's handling of BETWEEN. Done means the equivalent NOT BETWEEN query parses without the reported error and existing BETWEEN behavior remains intact.
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
- Mostly clear
- Newbie friendliness
- 48/100