SQLite Forum

FTS5 MATCH doesn't support AND NOT
Login
Chronological

FTS5 MATCH doesn't support AND NOT

(1) By anonymous on 2020-09-21 12:26:55 [source] 

SQLite 3.22.0 FTS5 MATCH causes an error when parsing `x AND NOT y`. Similarly, `x AND (NOT y)` causes the same error. It says `fts5: syntax error near "NOT"`.

I would really like for these to be supported in the same way that `x NOT y` and `x (NOT y)` are supported. I am receiving queries from an automated system and I cannot modify them, so this extra compatibility will help.

(2) By anonymous on 2020-09-21 15:24:16 in reply to 1 [link] [source] 

Correction: Disregard `x (NOT y)`; that doesn't work anyway, but it would be nice if it too worked.