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 transformation algorithm c
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 "mal
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?
Reg
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 dat
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 string.
--
D. Richard H
Hello,
I see a strange problem in sqlite with json and pehaps a bug.
I've a table with somes json record (when activityType=22) and not json
record (when activityType is not 22)
I need made somes complex request on json value.
And the request below give me an error "malformed JSON".
If we add ,
7 matches
Mail list logo