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
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
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
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?
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
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
6 matches
Mail list logo