Re: [sqlite] Strange problem (pehaps bug) with sqlite + json

2016-09-23 Thread Dominique Devienne
On Fri, Sep 23, 2016 at 11:58 AM, Hick Gunter wrote: > SQLite evaluates the WHERE clause from left to right, which means it needs > to evaluate xyz and thereby call json_extract first, even before it can > determine that no rows match the second condition. > > Maybe the

Re: [sqlite] Strange problem (pehaps bug) with sqlite + json

2016-09-23 Thread Hick Gunter
uot; first? -Ursprüngliche Nachricht- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Dan Kennedy Gesendet: Freitag, 23. September 2016 11:28 An: sqlite-users@mailinglists.sqlite.org Betreff: Re: [sqlite] Strange problem (pehaps bug) with sqlite + json

Re: [sqlite] Strange problem (pehaps bug) with sqlite + json

2016-09-23 Thread Dan Kennedy
On 09/23/2016 03:09 PM, Gilles Vollant wrote: With sqlite.exe from tools zipfile, I reproduce the bug with this script: If I add, just after the create table the line create index if not exists idxtype on records(activitytype); I have a correct result If I don't add the index, I've

Re: [sqlite] Strange problem (pehaps bug) with sqlite + json

2016-09-23 Thread Gilles Vollant
With sqlite.exe from tools zipfile, I reproduce the bug with this script: If I add, just after the create table the line create index if not exists idxtype on records(activitytype); I have a correct result If I don't add the index, I've "malformed json" error. Can you try reproduce?

Re: [sqlite] Strange problem (pehaps bug) with sqlite + json

2016-09-20 Thread Gilles Vollant
On 9/20/16, Richard Hipp wrote: > Maybe don't double the double-quotes. JSON expects just a single > double-quote a either end of a string. The tools I user (sqlite explorer) wanted it. And after I do update records set message=replace(message,'""','"'); So there is NO double quote in the

Re: [sqlite] Strange problem (pehaps bug) with sqlite + json

2016-09-20 Thread Richard Hipp
On 9/20/16, Gilles Vollant wrote: > > delete from records; > insert into records values (1,'2016-09-01',22,'{""Date"":""09/01/2016 > 02:00:00"",""CountAnalyzedMails"":44} '); Maybe don't double the double-quotes. JSON expects just a single double-quote a either end of a