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
>
--
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
