path: root/databases/sqlite3/Makefile.version
diff options
authoradam <>2015-10-15 17:31:32 +0000
committeradam <>2015-10-15 17:31:32 +0000
commitf5b5c5a402d9d4acb1b0079dc70ee35b7937b40c (patch)
tree94c7f6142a25dfba0c51a233e3a670e66a27d0ac /databases/sqlite3/Makefile.version
parent416f7b0fad14d0055aadeb4a028b222b69e4fe4a (diff)
Changes 3.9.0:
Policy Changes: * The version numbering conventions for SQLite are revised to use the emerging standard of semantic versioning. New Features And Enhancements: * Added the json1 extension module in the source tree, and in the amalgamation. Enable support using the SQLITE_ENABLE_JSON1 compile-time option. * Added Full Text Search version 5 (FTS5) to the amalgamation, enabled using SQLITE_ENABLE_FTS5. FTS5 will be considered "experimental" (subject to incompatible changes) for at least one more release cycle. * The CREATE VIEW statement now accepts an optional list of column names following the view name. * Added support for indexes on expressions. * Added support for table-valued functions in the FROM clause of a SELECT statement. * Added support for eponymous virtual tables. * A VIEW may now reference undefined tables and functions when initially created. Missing tables and functions are reported when the VIEW is used in a query. * Added the sqlite3_value_subtype() and sqlite3_result_subtype() interfaced (used by the json1 extension). * The query planner is now able to use partial indexes that contain AND-connected terms in the WHERE clause. * The sqlite3_analyzer.exe utility is updated to report the depth of each btree and to show the average fanout for indexes and WITHOUT ROWID tables. * Enhanced the dbstat virtual table so that it can be used as a table-valued function where the argument is the schema to be analyzed. Other changes: * The sqlite3_memory_alarm() interface, which has been deprecated and undocumented for 8 years, is changed into a no-op. Important fixes: * Fixed a critical bug in the SQLite Encryption Extension that could cause the database to become unreadable and unrecoverable if a VACUUM command changed the size of the encryption nonce. * Added a memory barrier in the implementation of sqlite3_initialize() to help ensure that it is thread-safe. * Fix the OR optimization so that it always ignores subplans that do not use an index. * Do not apply the WHERE-clause pushdown optimization on terms that originate in the ON or USING clause of a LEFT JOIN.
Diffstat (limited to 'databases/sqlite3/Makefile.version')
1 files changed, 3 insertions, 3 deletions
diff --git a/databases/sqlite3/Makefile.version b/databases/sqlite3/Makefile.version
index 8df4e481f6e..e353ebdb29d 100644
--- a/databases/sqlite3/Makefile.version
+++ b/databases/sqlite3/Makefile.version
@@ -1,7 +1,7 @@
-# $NetBSD: Makefile.version,v 1.6 2015/07/30 12:37:04 adam Exp $
+# $NetBSD: Makefile.version,v 1.7 2015/10/15 17:31:32 adam Exp $
# used by databases/sqlite3/Makefile
# used by databases/sqlite3-docs/Makefile
# used by databases/sqlite3-tcl/Makefile