Path to this page:
Subject: CVS commit: pkgsrc
From: Adam Ciarcinski
Date: 2020-08-19 07:48:37
Message id: 20200819054837.AD5C1FB28@cvs.NetBSD.org
Log Message:
sqlite3: updated to 3.33.0
SQLite Release 3.33.0
Support for UPDATE FROM following the PostgreSQL syntax.
Increase the maximum size of database files to 281 TB.
Extended the PRAGMA integrity_check statement so that it can optionally be \
limited to verifying just a single table and its indexes, rather than the entire \
database file.
Added the decimal extension for doing arbitrary-precision decimal arithmetic.
Enhancements to the ieee754 extension for working with IEEE 754 binary64 numbers.
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
Query planner improvements:
Add the ability to find a full-index-scan query plan for queries using INDEXED \
BY which previously would fail with "no query solution".
Do a better job of detecting missing, incomplete, and/or dodgy sqlite_stat1 data \
and generates good query plans in spite of the misinformation.
Improved performance of queries like "SELECT min(x) FROM t WHERE y IN \
(?,?,?)" assuming an index on t(x,y).
In WAL mode, if a writer crashes and leaves the shm file in an inconsistent \
state, subsequent transactions are now able to recover the shm file even if \
there are active read transactions. Before this enhancement, shm file recovery \
that scenario would result in an SQLITE_PROTOCOL error.
Files: