Partial traceback (bdb 18.1.32): Program received signal SIGSEGV, Segmentation fault. 0x00007ffff798e560 in jsonEachColumn () from ./lib/libdb_sql-18.1.so (gdb) bt full #0 0x00007ffff798e560 in jsonEachColumn () from ./lib/libdb_sql-18.1.so No symbol table info available. #1 0x00007ffff79b29b6 in sqlite3VdbeExec () from ./lib/libdb_sql-18.1.so No symbol table info available.
Unfortunately this is next-to-useless, but may provide a clue? On Tue, Jul 23, 2019 at 11:04 AM Carlo Innocenti <mino...@minollo.com> wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users