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
t;');
So there is NO double quote in the database.
Regards
Gilles Vollant
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
n_extract(jsonstr , '$.Date') as multiinfo,
json_extract(jsonstr , '$.Date') as Date,
json_extract(jsonstr , '$.CountAnalyzedMails') as CountEmails
from (
select *, length(message) as msglen,
message as jsonstr ,
json_valid(message) as is_json_valid
The crash occur with sqlite 3.7.8 on line below:
u.bp.pC->nullRow = (u8)u.bp.res;
u.bp.pC did not reference a valid address.
here is the stack
(gdb) bt
#0 0x00055000 in sqlite3VdbeExec (p=0x18e9d8) at
/Volumes/hfsdata/sqliteTest/sqlite/sqlite3.c:68038
#1 0x96d2 in sqlite3_step (pStm
Thank you a lot for your answer.
Do you known more about this bug? Is there any other documentation?
Does it affect other code? Will apple fix it soon?
My currenct solution was using sqlite 3.7.1
Regards
Gilles Vollant
Le jeudi 1 décembre 2011, James Berry a écrit :
> Gilles,
>
> Th
Hello,
I'm using a recompiled version of SQLite in one project (I need FTS3 and now
FTS4 support, which is not avaiable in the sqlite included in iOS).
So I just include "sqlite3.c" and "sqlite3.h" in my XCode projet.
I've discovered that using LLVM compiler of Xcode 4.2.1 on Mac OS Lion
targetin
6 matches
Mail list logo