[sqlite] Questions regarding the use of a "partial index" as a "covering index"

I get confusing (to me) results when toying with a query that I think should use a partial index as a "covering index". This is using sqlite 3.20.1 on Arch Linux x86_64. The examples listed below start from a new, empty database. *** Given a table and an index like this CREATE TABLE tab (x1

[sqlite] sqlite 3.20.1: Core dump when running query with json functions in subquery

I'm consistently getting a core dump for a query that has json functions in a subquery. The same functions work fine in other queries. I came up with this small example which triggers the crash for me when executed from the sqlite3 shell for a new, empty database: CREATE TABLE dataset ( doc