Re: [sqlite] json path escaping with double quote

On 13/6/62 23:45, gwenn wrote: Hello, With the json1 extension, we can escape special characters like '[' from being interpreted as an array index by wrapping the path in double quotes. But sometimes, it does not work: Thanks for reporting this. Now fixed here:  

Re: [sqlite] json path escaping with double quote

$ make quicktest is ok with the patch. I will try to provide some additional test cases. On Sat, Jun 15, 2019 at 10:37 AM gwenn wrote: > > Ok, > I tried to patch this line: > > diff --git a/ext/misc/json1.c b/ext/misc/json1.c > index d99d360b2..0bb4e1cee 100644 > --- a/ext/misc/json1.c > +++

Re: [sqlite] json path escaping with double quote

Ok, I tried to patch this line: diff --git a/ext/misc/json1.c b/ext/misc/json1.c index d99d360b2..0bb4e1cee 100644 --- a/ext/misc/json1.c +++ b/ext/misc/json1.c @@ -1123,7 +1123,7 @@ static JsonNode *jsonLookupStep( u32 iStart, iLabel; JsonNode *pNode; iStart =

[sqlite] json path escaping with double quote

Hello, With the json1 extension, we can escape special characters like '[' from being interpreted as an array index by wrapping the path in double quotes. But sometimes, it does not work: sqlite> CREATE TABLE test (data TEXT); sqlite> INSERT INTO test (data) VALUES ('{}'); sqlite> UPDATE test SET