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