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
