alibaba / alibaba/nquery

Support NOT BETWEEN

Open
#10 0 comments 0 reactions 0 assignees View on GitHub
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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.