- New Version 3.7.16:
* Added the PRAGMA foreign_key_check command.
* Added new extended error codes for all SQLITE_CONSTRAINT
errors
* Added the SQLITE_READONLY_ROLLBACK extended error code for
when a database cannot be opened because it needs rollback
recovery but is read-only.
* Added SQL functions unicode(A) and char(X1,...,XN).
* Performance improvements for PRAGMA incremental_vacuum,
especially in cases where the number of free pages is greater
than what will fit on a single trunk page of the freelist.
* Improved optimization of queries containing aggregate min() or
max().
* Enhance virtual tables so that they can potentially use an
index when the WHERE clause contains the IN operator.
* Allow indices to be used for sorting even if prior terms of
the index are constrained by IN operators in the WHERE clause.
* Enhance the PRAGMA table_info command so that the "pk" column
is an increasing integer to show the order of columns in the
primary key.
* Enhance the query optimizer to exploit transitive join
constraints.
* Performance improvements in the query optimizer.
* Allow the error message from PRAGMA integrity_check to be
longer than 20000 bytes.
* Improved name resolution for deeply nested queries.
* Added the test_regexp.c module as a demonstration of how to
implement the REGEXP operator.
* Improved error messages in the RTREE extension.
* Enhance the command-line shell so that a non-zero argument to
OBS-URL: https://build.opensuse.org/request/show/160225
OBS-URL: https://build.opensuse.org/package/show/openSUSE:Factory/sqlite3?expand=0&rev=50
* Added the PRAGMA foreign_key_check command.
* Added new extended error codes for all SQLITE_CONSTRAINT
errors
* Added the SQLITE_READONLY_ROLLBACK extended error code for
when a database cannot be opened because it needs rollback
recovery but is read-only.
* Added SQL functions unicode(A) and char(X1,...,XN).
* Performance improvements for PRAGMA incremental_vacuum,
especially in cases where the number of free pages is greater
than what will fit on a single trunk page of the freelist.
* Improved optimization of queries containing aggregate min() or
max().
* Enhance virtual tables so that they can potentially use an
index when the WHERE clause contains the IN operator.
* Allow indices to be used for sorting even if prior terms of
the index are constrained by IN operators in the WHERE clause.
* Enhance the PRAGMA table_info command so that the "pk" column
is an increasing integer to show the order of columns in the
primary key.
* Enhance the query optimizer to exploit transitive join
constraints.
* Performance improvements in the query optimizer.
* Allow the error message from PRAGMA integrity_check to be
longer than 20000 bytes.
* Improved name resolution for deeply nested queries.
* Added the test_regexp.c module as a demonstration of how to
implement the REGEXP operator.
* Improved error messages in the RTREE extension.
* Enhance the command-line shell so that a non-zero argument to
OBS-URL: https://build.opensuse.org/package/show/server:database/sqlite3?expand=0&rev=72
- New Version 3.7.15.2:
* Added the sqlite3_errstr() interface.
* Avoid invoking the sqlite3_trace() callback multiple times
when a statement is automatically reprepared due to
SQLITE_SCHEMA errors.
* Enhance IN operator processing to make use of indices with
numeric affinities.
* Do full-table scans using covering indices when possible,
under the theory that an index will be smaller and hence can
be scanned with less I/O.
* Enhance the query optimizer so that ORDER BY clauses are more
aggressively optimized, especially in joins where various
terms of the ORDER BY clause come from separate tables of the
join.
* Add the ability to implement FROM clause subqueries as
coroutines rather that manifesting the subquery into a
temporary table.
* Several enhancements the command-line shell.
* Added the busy_timeout pragma.
* Added the instr() SQL function.
* Added the SQLITE_FCNTL_BUSYHANDLER file control, used to allow
VFS implementations to get access to the busy handler
callback.
* The xDelete method in the built-in VFSes now return
SQLITE_IOERR_DELETE_NOENT if the file to be deleted does not
* exist.
* Bug fix: Avoid various concurrency problems in shared cache
mode.
* Bug fix: Avoid a deadlock or crash if the backup API, shared
cache, and the SQLite Encryption Extension are all used at
once.
* Bug fix: SQL functions created using the TCL interface honor
the "nullvalue" setting.
* Bug fix: Fix a 32-bit overflow problem on CREATE INDEX for
databases larger than 16GB.
* Bug fix: Avoid segfault when using the COLLATE operator inside
of a CHECK constraint or view in shared cache mode.
- Use %optflags for building
- Fix debuginfo in the Tcl bindings.
OBS-URL: https://build.opensuse.org/request/show/149874
OBS-URL: https://build.opensuse.org/package/show/openSUSE:Factory/sqlite3?expand=0&rev=49
- New version 3.7.14:
* Ensure that floating point values are preserved exactly when
reconstructing a database from the output of the ".dump"
command of the command-line shell.
* Added the sqlite3_close_v2() interface.
* Updated the command-line shell so that it can be built using
SQLITE_OMIT_FLOATING_POINT and SQLITE_OMIT_AUTOINIT.
* Enhancements to PRAGMA integrity_check and PRAGMA quick_check
so that they can optionally check just a single attached
database install of all attached databases.
* Enhancements to WAL mode processing that ensure that at least
one valid read-mark is available at all times, so that
read-only processes can always read the database.
* Performance enhancements in the sorter used by ORDER BY and CREATE INDEX.
* Added the SQLITE_DISABLE_FTS4_DEFERRED compile-time option.
* Better handling of aggregate queries where the aggregate
functions are contained within subqueries.
* Enhance the query planner so that it will try to use a
covering index on queries that make use of or optimization.
OBS-URL: https://build.opensuse.org/request/show/132547
OBS-URL: https://build.opensuse.org/package/show/server:database/sqlite3?expand=0&rev=64
