[sqlite] Will ROWID be required to be unique in contentless Full text search

My question is whether or not I can rely on my use of non-unique rowids in FTS5 contentless tables to remain unenforced into the future of SQLite or am I exploiting an oversight that may be resolved in the future? Details ... I have a key-value pair SQLite table (called props) used for storing

[sqlite] Compiler warning - signed unsigned mismatch if enable sorter references defined

Compiling the amalgamation (some previous versions including the current Version 3.25.2 (2018-09-25)) generates the following warning with SQLITE_ENABLE_SORTER_REFERENCES defined.  The build works fine and always has so this is really just benign. The warning is: sqlite3.c(106816): warning

[sqlite] Full text serch - Matching all except chosen

Forgive me if this is the wrong way to do this but I'm a newbie. I am using version 3.24.0 with FTS5 Is there a way to perform a full text search that returns every row except records matching a specified query string? The following does not work because of a syntax error as the syntax requires a