json_patch() was added to the json1 extension in SQLite 3.18.0, but the other functions were there in earlier versions as far back as SQLite 3.9.0. Looking at https://sqlitestudio.pl/index.rvt?act=changelog it appears the latest version of SQLiteStudio (3.1.1) is using SQLite 3.15.0, so that is consistent with it not supporting json_patch().
As for your own program, are you compiling the SQLite 3.18.0 (or later) amalgamation and linking it directly into your program, or are you using a version of SQLite which is supplied by your OS or a library, which might be an older version? You can check which version of SQLite your program is using with: SELECT sqlite_version() > On 25/06/2017, at 8:21 PM, Robert M. Münch <[email protected]> > wrote: > > Hi, I'm trying to use the json_patch function in a query and tried in > SQLiteStudio and my own program and both times I get a "Error: Database no > such function: json_patch" > > The query I want to do is: > > UPDATE json_products SET json_value = json_patch(json_value,'{"col-1":1000}') > > json_extract works and json_value too. So I'm really wondering why json_patch > is missing. I checked the sources, and the code is there. > > I really don't have an idea what's up here. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
