rpm/sqlite3
SHA256
1
0
Fork 0
forked from pool/sqlite3
Code Pull Requests Activity

- Update to 3.18.0

Browse Source 
* Added the PRAGMA optimize command
  * The SQLite version identifier returned by the sqlite_source_id()
    SQL function and the sqlite3_sourceid() C API and found in the
    SQLITE_SOURCE_ID macro is now a 64-digit SHA3-256 hash instead
    of a 40-digit SHA1 hash.
  * Added the json_patch() SQL function to the JSON1 extension.
  * Enhance the LIKE optimization so that it works for arbitrary
    expressions on the left-hand side as long as the LIKE pattern
    on the right-hand side does not begin with a digit or minus sign.
  * Added the sqlite3_set_last_insert_rowid() interface and use the
    new interface in the FTS3, FTS4, and FTS5 extensions to ensure
    that the sqlite3_last_insert_rowid() interface always returns
    reasonable values.
  * Enhance PRAGMA integrity_check and PRAGMA quick_check so that
    they verify CHECK constraints.
  * Enhance the query plans for joins to detect empty tables early
    and halt without doing unnecessary work.
  * Enhance the sqlite3_mprintf() family of interfaces and the
    printf SQL function to put comma separators at the thousands
    marks for integers, if the "," format modifier is used in
    between the "%" and the "d" (example: "%,d").
  * Added the -DSQLITE_MAX_MEMORY=N compile-time option.
  * Added the .sha3sum dot-command and the .selftest dot-command
    to the command-line shell
  * Begin enforcing SQLITE_LIMIT_VDBE_OP. This can be used, 
    for example, to prevent excessively large prepared statements 
    in systems that accept SQL queries from untrusted users.
  * Various performance improvements.
  * Ensure that indexed expressions with collating sequences are

OBS-URL: https://build.opensuse.org/package/show/server:database/sqlite3?expand=0&rev=183
This commit is contained in:
Ismail Dönmez
2017-03-31 12:08:39 +00:00
committed by Git OBS Bridge
parent b0e219d229
commit dce18f915e
6 changed files with 52 additions and 8 deletions
Download Patch File Download Diff File Expand all files Collapse all files

44
sqlite3.changes
View File

@@ -1,3 +1,47 @@
-------------------------------------------------------------------
Fri Mar 31 12:03:54 UTC 2017 - idonmez@suse.com
- Update to 3.18.0
* Added the PRAGMA optimize command
* The SQLite version identifier returned by the sqlite_source_id()
SQL function and the sqlite3_sourceid() C API and found in the
SQLITE_SOURCE_ID macro is now a 64-digit SHA3-256 hash instead
of a 40-digit SHA1 hash.
* Added the json_patch() SQL function to the JSON1 extension.
* Enhance the LIKE optimization so that it works for arbitrary
expressions on the left-hand side as long as the LIKE pattern
on the right-hand side does not begin with a digit or minus sign.
* Added the sqlite3_set_last_insert_rowid() interface and use the
new interface in the FTS3, FTS4, and FTS5 extensions to ensure
that the sqlite3_last_insert_rowid() interface always returns
reasonable values.
* Enhance PRAGMA integrity_check and PRAGMA quick_check so that
they verify CHECK constraints.
* Enhance the query plans for joins to detect empty tables early
and halt without doing unnecessary work.
* Enhance the sqlite3_mprintf() family of interfaces and the
printf SQL function to put comma separators at the thousands
marks for integers, if the "," format modifier is used in
between the "%" and the "d" (example: "%,d").
* Added the -DSQLITE_MAX_MEMORY=N compile-time option.
* Added the .sha3sum dot-command and the .selftest dot-command
to the command-line shell
* Begin enforcing SQLITE_LIMIT_VDBE_OP. This can be used,
for example, to prevent excessively large prepared statements
in systems that accept SQL queries from untrusted users.
* Various performance improvements.
* Ensure that indexed expressions with collating sequences are
handled correctly. Fix for ticket eb703ba7b50c1a5.
* Fix a bug in the 'start of ...' modifiers for the date and
time functions. Ticket 6097cb92745327a1
* Fix a potential segfault in complex recursive triggers,
resulting from a bug in the OP_Once opcode introduced as part
of a performance optimization in version 3.15.0. Ticket 06796225f59c057c
* In the RBU extension, add extra sync operations to avoid the
possibility of corruption following a power failure.
* The sqlite3_trace_v2() output for nested SQL statements should
always begin with a "--" comment marker.
-------------------------------------------------------------------
Wed Feb 15 18:30:53 UTC 2017 - dimstar@opensuse.org