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

[Martin Thierer]

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 TEXT
);
INSERT INTO dataset VALUES ('{"field1": [{"value": "val1"}, {"value":
"val2"}]');
INSERT INTO dataset VALUES ('{"field1": [{"value": "val3"}, {"value":
"val2"}]');
INSERT INTO dataset VALUES ('{"field1": [{"value": "val4"}, {"value":
"val1"}]');
SELECT * FROM dataset WHERE 'val1' IN
  (SELECT json_extract(json_each.value, '$.value')
    FROM json_each(json_extract(dataset.doc, '$.field')));

As I got syntax errors when copy-pasting even from my own email draft,
I also put it here:

https://gist.github.com/thierer/f4367232f58a452ff960fe61c3250fbe

This is with sqlite 3.20.1 on Arch Linux x86_64.

Thanks! (both for looking into this issue and sqlite in general...)

Martin
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users