- Added improve for approximate ANALYZE using the
PRAGMA analysis_limit elaborate.
- Added the bytecode digital desk.
- Add the checksum VFS shim to the connect of flee-time loadable
extensions included inside the provision tree.
- Added the iif() SQL feature.
- INSERT and UPDATE statements now always bear in mind column affinity
prior to computing CHECK constraints. This laptop virus restore may effectively perchance, in
perception, connect off concerns for legacy databases with unorthodox
CHECK constraints the require the enter type for an INSERT
is diversified from the declared column type. Gaze tag
for extra information.
- Added the sqlite3_create_filename(), sqlite3_free_filename(),
interfaces to raised improve of VFS shim implementations.
- Develop the default better certain
on the amount of parameters from 999 to 32766.
- Added code for the UINT collating sequence as an elective
- Enhancements to the CLI:
- Add alternate choices to the .import elaborate: –csv, –ascii, –skip
- The .dump elaborate now accepts just some LIKE-sample arguments
and outputs the union of all matching tables.
- Add the .oom elaborate in debugging builds
- Add the –bom chance to the .excel, .output, and .once
- Toughen the .filectrl elaborate to reinforce the –schema chance.
- The UINT collating sequence extension is robotically loaded
- The ESCAPE clause of a LIKE operator now overrides wildcard
characters, in order that the habits now fits what PostgreSQL does.
- SQLITE_SOURCE_ID: 2020-05-22 17: 46: 16 5998789c9c744bce92e4cff7636bba800a75574243d6977e1fc8281e360f8d5a
- SHA3-256 for sqlite3.c: 33ed868b21b62ce1d0352ed88bdbd9880a42f29046497a222df6459fc32a356f
A total list of SQLite releases
in a single web web page and a chronology are each moreover available.
An in depth historical past of each
confirm-in is available at
SQLite model retain an eye on attach.