- update to 3.10.0
- spec-cleaned
* Added support for LIKE, GLOB, and REGEXP operators on virtual tables.
* Added the colUsed field to sqlite3_index_info for use by the
sqlite3_module.xBestIndex method.
* Enhance the PRAGMA cache_spill statement to accept a 32-bit integer parameter
which is the threshold below which cache spilling is prohibited.
* On unix, if a symlink to a database file is opened, then the corresponding
journal files are based on the actual filename, not the symlink name.
* Added the "--transaction" option to sqldiff.
* Added the sqlite3_db_cacheflush() interface.
* Added the sqlite3_strlike() interface.
* When using memory-mapped I/O map the database file read-only so that stray
pointers and/or array overruns in the application cannot accidently modify
the database file.
* Added the experimental sqlite3_snapshot_get(), sqlite3_snapshot_open(), and
sqlite3_snapshot_free() interfaces. These are subject to change or removal in
a subsequent release.
* Enhance the 'utc' modifier in the date and time functions so that it is a no-op
if the date/time is known to already be in UTC. (This is not a compatibility
break since the behavior has long been documented as "undefined" in that case.)
* Added the json_group_array() and json_group_object() SQL functions in the json
extension.
* Added the SQLITE_LIKE_DOESNT_MATCH_BLOBS compile-time option.
* Many small performance optimizations.
+ Enhancements to the command-line shell:
* Added the ".changes ON|OFF" and ".vfsinfo" dot-commands.
+ Important fixes:
* Fix inconsistent integer to floating-point comparison operations that could
result in a corrupt index if the index is created on a table column that
OBS-URL: https://build.opensuse.org/request/show/352452
OBS-URL: https://build.opensuse.org/package/show/server:database/sqlite3?expand=0&rev=138
- Update to SQLite 3.8.10
* Added the y format string to the matchinfo() function of FTS3.
* Performance improvements for ORDER BY, VACUUM, CREATE INDEX,
PRAGMA integrity_check, and PRAGMA quick_check
* Fix many obscure problems discovered while SQL fuzzing.
* Add the ".binary" and ".limits" commands to the command-line shell
* Make the "dbstat" virtual table part of standard builds
when compiled with the SQLITE_ENABLE_DBSTAT_VTAB option.
OBS-URL: https://build.opensuse.org/request/show/305821
OBS-URL: https://build.opensuse.org/package/show/server:database/sqlite3?expand=0&rev=124
* 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
* 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.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
