SQLite

View Ticket
Login
Ticket Hash: 2b8aed9f7c9e61e8d417ce1994b7ca75d9eda2cb
Title: Misbehavior in the FTS5 xBestIndex method
Status: Fixed Type: Code_Defect
Severity: Severe Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2018-04-09 15:58:07
Version Found In: 3.23.0
User Comments:
drh added on 2018-04-09 14:20:30:

The xBestIndex method of the FTS5 virtual table misbehaves in the following input:

CREATE VIRTUAL TABLE ft USING fts5(x);
SELECT * FROM ft WHERE ft.rowid IS NULL;

The above results in an error: "ft.xBestIndex malfunction". In other queries, this malfunction might result in memory leaks or even NULL pointer dereferences.