| 3.50.0
| - (7) Changes to JSON functions:
- Bug fix: Enforce the JSON5 restriction that the
"\0" escape must not be followed by a digit.
- Bug fix: When the LABEL argument to json_group_object(LABEL,VALUE)
is NULL, that element of the resulting object is omitted.
- Optimization:
If the jsonb_set() or jsonb_replace() functions make a change in the
interior of a large JSONB object, they strive to keep the size of the
JSONB object unchanged and to modify as few bytes as possible on the interior
of the object. This helps reduce I/O as it allows SQLite to write only
the page that contains the changed bytes and not all the surrounding pages.
| 3.46.0
| - (7) JSON changes:
- Allow ASCII control characters within JSON5 string literals.
- Fix the -> and ->> operators so that when the right-hand side operand is a string
that looks like an integer it is still treated as a string, because that is what
PostgreSQL does.
| 3.45.1
| - (1) Restore the JSON BLOB input bug, and promise to support the anomaly in
subsequent releases, for backward compatibility.
| 3.45.0
| - (2) Enhancements to the JSON SQL functions:
- All JSON functions are rewritten to use a new internal parse tree
format called JSONB. The new parse-tree format is serializable
and hence can be stored in the database to avoid unnecessary re-parsing
whenever the JSON value is used.
- New versions of JSON-generating functions generate binary JSONB instead
of JSON text.
- The json_valid() function adds an optional second argument that
specifies what it means for the first argument to be "well-formed".
| 3.43.0
| - (7) Performance enhancements to JSON processing results in a 2x performance
improvement for some kinds of processing on large JSON strings.
| 3.42.0
| - (2) Enhance the JSON SQL functions to support JSON5 extensions.
- (12) The maximum recursion depth for JSON arrays and objects is lowered from 2000
to 1000.
| 3.38.0
| - (1) Added the -> and ->> operators for easier processing of JSON.
The new operators are compatible with MySQL and PostgreSQL.
- (2) The JSON functions are now built-ins. It is no longer necessary
to use the -DSQLITE_ENABLE_JSON1 compile-time option to enable JSON
support. JSON is on by default. Disable the JSON interface using
the new -DSQLITE_OMIT_JSON compile-time option.
| 3.33.0
| - (6) CLI enhancements:
- Added four new output modes: "box", "json", "markdown",
and "table".
- The "column" output mode automatically expands columns to
contain the longest output row and automatically turns
".header" on if it has not been previously set.
- The "quote" output mode honors ".separator"
- The decimal extension and the ieee754 extension are built-in to the CLI
| 3.31.0
| - (6) Added the "#-N" array notation for JSON function path arguments.
| 3.19.0
| - (12) Enhance the json_extract() function to cache and reuse parses of JSON
input text.
- (18) Disallow leading zeros in numeric constants in JSON. Fix for ticket
b93be8729a895a528e2.
- (19) Disallow control characters inside of strings in JSON. Fix for ticket
6c9b5514077fed34551.
- (20) Limit the depth of recursion for JSON objects and arrays in order to avoid
excess stack usage in the recursive descent parser. Fix for ticket
981329adeef51011052.
| 3.15.2
| - (4) In the JSON extension, fix the JSON validator so that it correctly rejects
invalid backslash escapes within strings.
| 3.11.0
| |
|
|
|
|
|
|
|
|
|
|
|
