Re: [sqlite] Seg fault using json_each() subquery

Carlo -- how do you get in touch with the BerkeleyDB folks? I've found and fixed a couple issues with their SQLite build and have found no better option that to post it on their "forum" and hope someone finds it. Example I posted a few weeks ago with no response:

Re: [sqlite] Seg fault using json_each() subquery

To close this thread, it looks like this issue is about a sqlite bug which was fixed last year: http://www2.sqlite.org/cgi/src/info/7daa687340e47597 Applying the changes described there to the BDB/SQLite code fixed the issue I was experiencing. Thanks for all the help, Minollo

Re: [sqlite] Seg fault using json_each() subquery

ven says a lot about anticipated traffic volume. >/-Original Message- />/From: sqlite-users [mailto:sqlite-users- />/bounces at mailinglists.sqlite.org <http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users>] On Behalf Of Charles Leifer />/Sent: T

Re: [sqlite] Seg fault using json_each() subquery

sers- >boun...@mailinglists.sqlite.org] On Behalf Of Charles Leifer >Sent: Tuesday, 23 July, 2019 20:08 >To: SQLite mailing list >Subject: Re: [sqlite] Seg fault using json_each() subquery > >Partial traceback (bdb 18.1.32): > >Program received signal SIGSEGV, Segmentation fa

Re: [sqlite] Seg fault using json_each() subquery

Partial traceback (bdb 18.1.32): Program received signal SIGSEGV, Segmentation fault. 0x7798e560 in jsonEachColumn () from ./lib/libdb_sql-18.1.so (gdb) bt full #0 0x7798e560 in jsonEachColumn () from ./lib/libdb_sql-18.1.so No symbol table info available. #1 0x779b29b6

Re: [sqlite] Seg fault using json_each() subquery

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?

Re: [sqlite] Seg fault using json_each() subquery

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 wrote: > I have a segmentation fault which happens when trying to run a subquery > based on json_each() if the argument is

[sqlite] Seg fault using json_each() subquery

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