Re: [sqlite] sqlite 3.20.1: Core dump when running query with json functions in subquery

Thanks that runs fine now. RBS On Mon, Sep 4, 2017 at 8:45 AM, Richard Hipp wrote: > On 9/4/17, Bart Smissaert wrote: > > > > malformed JSON > > > > SQLite should never segfault, regardless of whether or not the JSON is > malformed. > > The ticket

Re: [sqlite] sqlite 3.20.1: Core dump when running query with json functions in subquery

Thanks, this runs OK now. I am not familiar with JSON, but was just trying this out and see if I could make it work in SQLite. RBS On Mon, Sep 4, 2017 at 8:40 AM, Rowan Worth wrote: > On 4 September 2017 at 15:37, Bart Smissaert > wrote: > > >

Re: [sqlite] sqlite 3.20.1: Core dump when running query with json functions in subquery

On 9/4/17, Bart Smissaert wrote: > > malformed JSON > SQLite should never segfault, regardless of whether or not the JSON is malformed. The ticket (https://sqlite.org/src/info/b899b6042f97f5) shows a modified test case that uses no JSON at all. -- D. Richard Hipp

Re: [sqlite] sqlite 3.20.1: Core dump when running query with json functions in subquery

On 4 September 2017 at 15:37, Bart Smissaert wrote: > Trying this out, so I edited the source and indeed now there is no crash. > I get however a message: > > malformed JSON > > This is the dump of that testing table, dataset: > > doc > {"field1": [{"value": "val1"},

Re: [sqlite] sqlite 3.20.1: Core dump when running query with json functions in subquery

Trying this out, so I edited the source and indeed now there is no crash. I get however a message: malformed JSON This is the dump of that testing table, dataset: doc {"field1": [{"value": "val1"}, {"value": "val2"}] {"field1": [{"value": "val3"}, {"value": "val2"}] {"field1": [{"value":

Re: [sqlite] sqlite 3.20.1: Core dump when running query with json functions in subquery

A proposed fix for this problem is now on trunk. On 9/3/17, Richard Hipp wrote: > On 9/3/17, Martin Thierer wrote: >> I'm consistently getting a core dump for a query that has json >> functions in a subquery. The same functions work fine in other >>

Re: [sqlite] sqlite 3.20.1: Core dump when running query with json functions in subquery

On 9/3/17, Martin Thierer wrote: > I'm consistently getting a core dump for a query that has json > functions in a subquery. The same functions work fine in other > queries. Thanks for the concise bug report. A ticket is here: https://sqlite.org/src/tktview/b899b6042f97f

[sqlite] sqlite 3.20.1: Core dump when running query with json functions in subquery

I'm consistently getting a core dump for a query that has json functions in a subquery. The same functions work fine in other queries. I came up with this small example which triggers the crash for me when executed from the sqlite3 shell for a new, empty database: CREATE TABLE dataset ( doc