can result in a crash during heavy SAVEPOINT usage.
- Fix views so that they inherit column datatypes from the table
that they are defined against, when possible.
- Fix the query planner so that IS and IS NULL operators are able to
drive an index on a LEFT OUTER JOIN.
OBS-URL: https://build.opensuse.org/package/show/server:database/sqlite3?expand=0&rev=157
- SQLite 3.12.0:
* The SQLITE_DEFAULT_PAGE_SIZE is increased from 1024 to 4096.
The SQLITE_DEFAULT_CACHE_SIZE is changed from 2000 to -2000
so the same amount of cache memory is used by default.
* Enhancements to the Lemon parser generator so that it creates
a smaller and faster SQL parser.
* Only create master journal files if two or more attached databases
are all modified, do not have PRAGMA synchronous set to OFF,
and do not have the journal_mode set to OFF, MEMORY, or WAL.
* Added the SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER option to
sqlite3_db_config() which allows the two-argument version of the
fts3_tokenizer() SQL function to be enabled or disabled at run-time.
* Added the sqlite3rbu_bp_progress() interface to the RBU extension.
* The PRAGMA defer_foreign_keys=ON statement now also disables RESTRICT
actions on foreign key.
* Added the sqlite3_system_errno() interface.
* Added the SQLITE_DEFAULT_SYNCHRONOUS and SQLITE_DEFAULT_WAL_SYNCHRONOUS
compile-time options. The SQLITE_DEFAULT_SYNCHRONOUS compile-time option
replaces the SQLITE_EXTRA_DURABLE option, which is no longer supported.
* Enhanced the ".stats" command in the command-line shell to show more
information about I/O performance obtained from /proc, when available.
* Make sure the sqlite3_set_auxdata() values from multiple triggers within
a single statement do not interfere with one another. Ticket dc9b1c91.
* Fix the code generator for expressions of the form "x IN (SELECT...)"
where the SELECT statement on the RHS is a correlated subquery.
- Remove sqlite3-link-binary-with-libsqlite3.patch: replaced with configure
option --disable-static-shell
OBS-URL: https://build.opensuse.org/request/show/381471
OBS-URL: https://build.opensuse.org/package/show/openSUSE:Factory/sqlite3?expand=0&rev=85
* The SQLITE_DEFAULT_PAGE_SIZE is increased from 1024 to 4096.
The SQLITE_DEFAULT_CACHE_SIZE is changed from 2000 to -2000
so the same amount of cache memory is used by default.
* Enhancements to the Lemon parser generator so that it creates
a smaller and faster SQL parser.
* Only create master journal files if two or more attached databases
are all modified, do not have PRAGMA synchronous set to OFF,
and do not have the journal_mode set to OFF, MEMORY, or WAL.
* Added the SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER option to
sqlite3_db_config() which allows the two-argument version of the
fts3_tokenizer() SQL function to be enabled or disabled at run-time.
* Added the sqlite3rbu_bp_progress() interface to the RBU extension.
* The PRAGMA defer_foreign_keys=ON statement now also disables RESTRICT
actions on foreign key.
* Added the sqlite3_system_errno() interface.
* Added the SQLITE_DEFAULT_SYNCHRONOUS and SQLITE_DEFAULT_WAL_SYNCHRONOUS
compile-time options. The SQLITE_DEFAULT_SYNCHRONOUS compile-time option
replaces the SQLITE_EXTRA_DURABLE option, which is no longer supported.
* Enhanced the ".stats" command in the command-line shell to show more
information about I/O performance obtained from /proc, when available.
* Make sure the sqlite3_set_auxdata() values from multiple triggers within
a single statement do not interfere with one another. Ticket dc9b1c91.
* Fix the code generator for expressions of the form "x IN (SELECT...)"
where the SELECT statement on the RHS is a correlated subquery.
- Remove sqlite3-link-binary-with-libsqlite3.patch: replaced with configure
option --disable-static-shell
OBS-URL: https://build.opensuse.org/package/show/server:database/sqlite3?expand=0&rev=155
- Fix sqlite-fts5-link.patch: link libsqlite3.so with libm instead
of the sqlite3 binary: the library is the actual user of log().
- Add sqlite3-link-binary-with-libsqlite3.patch: dyamically link
/usr/bin/sqlite3 to libsqlite3 instead of statically using it.
- Move autoreconf call to build section, where it belongs.
- Enable FTS5 support.
- Add sqlite-fts5-link.patch to link to math library because FTS5
code uses log().
- SQLite 3.11.1:
* Fix an FTS5 issue in which the 'optimize' command could cause
index corruption.
* Fix a buffer overread that might occur if FTS5 is used to query
a corrupt database file.
* Increase the maximum "scope" value for the spellfix1 extension
from 6 to 30.
- explicitly enable readline support
- run spec-cleaner
OBS-URL: https://build.opensuse.org/request/show/367794
OBS-URL: https://build.opensuse.org/package/show/openSUSE:Factory/sqlite3?expand=0&rev=83
- 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
