/ 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: (text/x-fossil-wiki)
The xBestIndex method of the FTS5 virtual table misbehaves in the following
input:

<blockquote><verbatim>
CREATE VIRTUAL TABLE ft USING fts5(x);
SELECT * FROM ft WHERE ft.rowid IS NULL;
</verbatim></blockquote>

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