From 471d8dcbc701bcee3bfe5232e3d1834e5ef99bd7 Mon Sep 17 00:00:00 2001 From: adam Date: Sun, 28 Nov 2021 20:48:28 +0000 Subject: sqlite3: updated to 3.37.0 SQLite Release 3.37.0 On 2021-11-27 STRICT tables provide a prescriptive style of data type management, for developers who prefer that kind of thing. When adding columns that contain a CHECK constraint or a generated column containing a NOT NULL constraint, the ALTER TABLE ADD COLUMN now checks new constraints against preexisting rows in the database and will only proceed if no constraints are violated. Added the PRAGMA table_list statement. CLI enhancements: Add the .connection command, allowing the CLI to keep multiple database connections open at the same time. Add the --safe command-line option that disables dot-commands and SQL statements that might cause side-effects that extend beyond the single database file named on the command-line. Performance improvements when reading SQL statements that span many lines. Added the sqlite3_autovacuum_pages() interface. The sqlite3_deserialize() does not and has never worked for the TEMP database. That limitation is now noted in the documentation. The query planner now omits ORDER BY clauses on subqueries and views if removing those clauses does not change the semantics of the query. The generate_series table-valued function extension is modified so that the first parameter ("START") is now required. This is done as a way to demonstrate how to write table-valued functions with required parameters. The legacy behavior is available using the -DZERO_ARGUMENT_GENERATE_SERIES compile-time option. Added new sqlite3_changes64() and sqlite3_total_changes64() interfaces. Added the SQLITE_OPEN_EXRESCODE flag option to sqlite3_open_v2(). Use less memory to hold the database schema. --- databases/sqlite3-docs/PLIST | 7 ++++++- databases/sqlite3-docs/distinfo | 8 ++++---- 2 files changed, 10 insertions(+), 5 deletions(-) (limited to 'databases/sqlite3-docs') diff --git a/databases/sqlite3-docs/PLIST b/databases/sqlite3-docs/PLIST index 47fc977a0f7..88cd0ede5fa 100644 --- a/databases/sqlite3-docs/PLIST +++ b/databases/sqlite3-docs/PLIST @@ -1,4 +1,4 @@ -@comment $NetBSD: PLIST,v 1.104 2021/06/25 21:21:31 adam Exp $ +@comment $NetBSD: PLIST,v 1.105 2021/11/28 20:48:28 adam Exp $ share/doc/sqlite3/34to35.html share/doc/sqlite3/35to36.html share/doc/sqlite3/about.html @@ -20,6 +20,7 @@ share/doc/sqlite3/c3ref/aggregate_context.html share/doc/sqlite3/c3ref/aggregate_count.html share/doc/sqlite3/c3ref/api_routines.html share/doc/sqlite3/c3ref/auto_extension.html +share/doc/sqlite3/c3ref/autovacuum_pages.html share/doc/sqlite3/c3ref/backup.html share/doc/sqlite3/c3ref/backup_finish.html share/doc/sqlite3/c3ref/bind_blob.html @@ -270,6 +271,7 @@ share/doc/sqlite3/features.html share/doc/sqlite3/fileformat.html share/doc/sqlite3/fileformat2.html share/doc/sqlite3/fileio.html +share/doc/sqlite3/flextypegood.html share/doc/sqlite3/floatingpoint.html share/doc/sqlite3/footprint.html share/doc/sqlite3/foreignkeys.html @@ -631,6 +633,7 @@ share/doc/sqlite3/releaselog/3_35_3.html share/doc/sqlite3/releaselog/3_35_4.html share/doc/sqlite3/releaselog/3_35_5.html share/doc/sqlite3/releaselog/3_36_0.html +share/doc/sqlite3/releaselog/3_37_0.html share/doc/sqlite3/releaselog/3_3_0.html share/doc/sqlite3/releaselog/3_3_1.html share/doc/sqlite3/releaselog/3_3_10.html @@ -829,6 +832,7 @@ share/doc/sqlite3/sqlite.css share/doc/sqlite3/sqlite.css~ share/doc/sqlite3/sqlite.html share/doc/sqlite3/stmt.html +share/doc/sqlite3/stricttables.html share/doc/sqlite3/support.html share/doc/sqlite3/swarmvtab.html share/doc/sqlite3/syntax.html @@ -892,6 +896,7 @@ share/doc/sqlite3/syntax/simple-select-stmt.html share/doc/sqlite3/syntax/sql-stmt-list.html share/doc/sqlite3/syntax/sql-stmt.html share/doc/sqlite3/syntax/table-constraint.html +share/doc/sqlite3/syntax/table-options.html share/doc/sqlite3/syntax/table-or-subquery.html share/doc/sqlite3/syntax/type-name.html share/doc/sqlite3/syntax/update-stmt-limited.html diff --git a/databases/sqlite3-docs/distinfo b/databases/sqlite3-docs/distinfo index e4fe07282a9..150ee2f4cc9 100644 --- a/databases/sqlite3-docs/distinfo +++ b/databases/sqlite3-docs/distinfo @@ -1,5 +1,5 @@ -$NetBSD: distinfo,v 1.107 2021/10/26 10:10:05 nia Exp $ +$NetBSD: distinfo,v 1.108 2021/11/28 20:48:28 adam Exp $ -BLAKE2s (sqlite-doc-3360000.zip) = 4bf60a58ed2f84cb9993fec9723875b6e67d15c230c2a6829a010355a22c4db4 -SHA512 (sqlite-doc-3360000.zip) = c9b5628f823c322688e2fcce0effe7564dccaf8bcdbb3397ee09c433975bfb5fd63fd81830c5c6d573314e1e55d25cdf1b3842d798f7be63b9b88b32f6694add -Size (sqlite-doc-3360000.zip) = 12274411 bytes +BLAKE2s (sqlite-doc-3370000.zip) = 805b096d27353253ddf402e7a3447ee58628bdfb4ca89a633683345a4cf10522 +SHA512 (sqlite-doc-3370000.zip) = f245731675c67347318578e773b8d5f548c26eac7a333d6028cf7e11c4c9d2c3314da0a5428533ff26416f4194dce5c805d7f61f1fef27e02e9b91efa3c6d4c7 +Size (sqlite-doc-3370000.zip) = 10509325 bytes -- cgit v1.2.3