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

2017-09-04 Thread Bart Smissaert
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 (https://sqlite.org/src/info/b899b6042f97f5) s

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

2017-09-04 Thread Bart Smissaert
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: > > > Trying this out, so I edited the source and inde

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

2017-09-04 Thread Richard Hipp
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 d...@sqlite.org __

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

2017-09-04 Thread Rowan Worth
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"}, {"value": "val2"}] > {"field1

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

2017-09-04 Thread Bart Smissaert
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": "val4"}

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

2017-09-03 Thread Richard Hipp
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 >> queries. > > Thanks for the concise bug repor

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

2017-09-03 Thread Richard Hipp
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 I'm away from the offic

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

2017-09-03 Thread Martin Thierer
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 TEX