I have a segmentation fault which happens when trying to run a subquery
based on json_each() if the argument is the value of an outer
json_each() row:
CREATE TABLE mimmo (key TEXT PRIMARY KEY, value TEXT, valueJson
TEXT, blockNo INTEGER, txnNo INTEGER, metadata TEXT);
INSER INTO mimmo (key, valueJson) VALUES ('key2',
'{"peppo":[["a","b"],["c","d"]]}');
SELECT s.key FROM mimmo AS s, json_each(json_extract(s.valueJson,
'$.peppo')) AS a WHERE (SELECT COUNT(*) FROM json_each(a.value)) > 0;
sqlite> select sqlite_version();
3.18.2
Am I doing anything obviously wrong? Or is this a known problem/limitation?
Thanks!
Minollo
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
