- New version: 3.8.3:
* Added support for common table expressions and the WITH
clause.
* Added the printf() SQL function.
* Added SQLITE_DETERMINISTIC as an optional bit in the 4th
argument to the sqlite3_create_function() and related
interfaces, providing applications with the ability to create
new functions that can be factored out of inner loops when
they have constant arguments.
* Add SQLITE_READONLY_DBMOVED error code, returned at the
beginning of a transaction, to indicate that the underlying
database file has been renamed or moved out from under SQLite.
* Allow arbitrary expressions, including function calls and
subqueries, in the filename argument to ATTACH.
* Allow a VALUES clause to be used anywhere a SELECT statement
is valid.
* Reseed the PRNG used by sqlite3_randomness(N,P) when invoked
with N==0. Automatically reseed after a fork() on unix.
* Enhance the spellfix1 virtual table so that it can search
efficiently by rowid.
* Performance enhancements.
* Improvements to the comments in the VDBE byte-code display
when running EXPLAIN.
* Add the "%token_class" directive to LEMON parser generator and
use it to simplify the grammar.
* Change the LEMON source code to avoid calling C-library
functions that OpenBSD considers dangerous. (Ex: sprintf).
* Bug fix: In the command-line shell CSV import feature, do not
end a field when an escaped double-quote occurs at the end of
a CRLN line.
OBS-URL: https://build.opensuse.org/request/show/220845
OBS-URL: https://build.opensuse.org/package/show/openSUSE:Factory/sqlite3?expand=0&rev=57
* Added support for common table expressions and the WITH
clause.
* Added the printf() SQL function.
* Added SQLITE_DETERMINISTIC as an optional bit in the 4th
argument to the sqlite3_create_function() and related
interfaces, providing applications with the ability to create
new functions that can be factored out of inner loops when
they have constant arguments.
* Add SQLITE_READONLY_DBMOVED error code, returned at the
beginning of a transaction, to indicate that the underlying
database file has been renamed or moved out from under SQLite.
* Allow arbitrary expressions, including function calls and
subqueries, in the filename argument to ATTACH.
* Allow a VALUES clause to be used anywhere a SELECT statement
is valid.
* Reseed the PRNG used by sqlite3_randomness(N,P) when invoked
with N==0. Automatically reseed after a fork() on unix.
* Enhance the spellfix1 virtual table so that it can search
efficiently by rowid.
* Performance enhancements.
* Improvements to the comments in the VDBE byte-code display
when running EXPLAIN.
* Add the "%token_class" directive to LEMON parser generator and
use it to simplify the grammar.
* Change the LEMON source code to avoid calling C-library
functions that OpenBSD considers dangerous. (Ex: sprintf).
* Bug fix: In the command-line shell CSV import feature, do not
end a field when an escaped double-quote occurs at the end of
a CRLN line.
OBS-URL: https://build.opensuse.org/package/show/server:database/sqlite3?expand=0&rev=88
- 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
