I'm using sqlite with BDB as the persistence store; if you can't
reproduce it (same sqlite version), I suppose it means it's a BerkeleyDB
issue, and I'll follow up with them.
Thanks!
On 7/23/2019 12:01, Richard Hipp wrote:
Unable to reproduce. Are you sure you are sending the correct script?
What operating system are you running on? How did you compile
SQLite?
On 7/23/19, Carlo Innocenti <mino...@minollo.com> wrote:
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',
Did you mean to say "INSERT" here, instead of "INSER"?
'{"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
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
