Overview Repositories Revisions Requests Users Attributes Meta

Revisions of sqlite3

Reinhard Max's avatar Reinhard Max (rmax) committed (revision 197) 
- Revert last change.
Martin Pluskal's avatar Martin Pluskal (pluskalm) committed (revision 196) 
- Enable fts3_tokenizer() (disabled by default with 3.11.0)
buildservice-autocommit accepted request 519652 from Martin Pluskal's avatar Martin Pluskal (pluskalm) (revision 195) 
baserev update by copy to link target
buildservice-autocommit accepted request 513779 from Martin Pluskal's avatar Martin Pluskal (pluskalm) (revision 193) 
baserev update by copy to link target
buildservice-autocommit accepted request 504012 from Martin Pluskal's avatar Martin Pluskal (pluskalm) (revision 191) 
baserev update by copy to link target
Martin Pluskal's avatar Martin Pluskal (pluskalm) accepted request 504009 from Andreas Stieger's avatar Andreas Stieger (AndreasStieger) (revision 190) 
- a little less packaging cleanup so as to not break SLE 11 SP4
Martin Pluskal's avatar Martin Pluskal (pluskalm) committed (revision 189) 
- Small packaging cleanup
Martin Pluskal's avatar Martin Pluskal (pluskalm) accepted request 502499 from Andreas Stieger's avatar Andreas Stieger (AndreasStieger) (revision 188) 
- Update to 3.19.3:
  * Fix a bug associated with auto_vacuum that can lead to database
    corruption. (introduced in 3.16.0)
buildservice-autocommit accepted request 498338 from Ismail Dönmez's avatar Ismail Dönmez (namtrac) (revision 187) 
baserev update by copy to link target
Ismail Dönmez's avatar Ismail Dönmez (namtrac) committed (revision 186) 
- Update to 3.19.2
  * Fix a bug in the LEFT JOIN flattening optimization.
    Ticket cad1ab4cb7b0fc.
  * Fix more bugs in the LEFT JOIN flattening optimization.
    Ticket 7fde638e94287d2c.
Ismail Dönmez's avatar Ismail Dönmez (namtrac) committed (revision 185) 
- Update to 3.19.0
  * The SQLITE_READ authorizer callback is invoked once with a
    column name that is an empty string for every table referenced
    in a query from which no columns are extracted.
  * When using an index on an expression, try to use expression
    values already available in the index, rather than loading
    the original columns and recomputing the expression.
  * Enhance the flattening optimization so that it is able to
    flatten views on the right-hand side of a LEFT JOIN.
  * Use replace() instead of char() for escaping newline and
    carriage-return characters embedded in strings in the .dump
    output from the command-line shell.
  * Avoid unnecessary foreign key processing in UPDATE statements
    that do not touch the columns that are constrained by the
    foreign keys.
  * On a DISTINCT query that uses an index, try to skip ahead
    to the next distinct entry using the index rather than
    stepping through rows, when an appropriate index is available.
  * Avoid unnecessary invalidation of sqlite3_blob handles
    when making changes to unrelated tables.
  * Transfer any terms of the HAVING clause that use only
    columns mentioned in the GROUP BY clause over to the
    WHERE clause for faster processing.
  * Reuse the same materialization of a VIEW if that VIEW
    appears more than once in the same query.
  * Enhance PRAGMA integrity_check so that it identifies
    tables that have two or more rows with the same rowid.
  * Enhance the FTS5 query syntax so that column filters
    may be applied to arbitrary expressions.
  * Enhance the json_extract() function to cache and
buildservice-autocommit accepted request 484084 from Ismail Dönmez's avatar Ismail Dönmez (namtrac) (revision 184) 
baserev update by copy to link target
Ismail Dönmez's avatar Ismail Dönmez (namtrac) committed (revision 183) 
- 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
buildservice-autocommit accepted request 457539 from Martin Pluskal's avatar Martin Pluskal (pluskalm) (revision 182) 
baserev update by copy to link target
Martin Pluskal's avatar Martin Pluskal (pluskalm) accepted request 457523 from Dominique Leuenberger's avatar Dominique Leuenberger (dimstar) (revision 181) 
- Drop update-desktop-files BuildRequires: this package contains no
  desktop files, hence there is no need to handle any of them.
Ismail Dönmez's avatar Ismail Dönmez (namtrac) committed (revision 180) 
- Update to 3.17.0
  * Approximately 25% better performance from the R-Tree extension.
  * Add the SQLITE_DEFAULT_LOOKASIDE compile-time option.
  * Increase the default lookaside size from 512,125 to 1200,100
    as this provides better performance while only adding 56KB of
    extra memory per connection.
  * Use compiler built-ins __builtin_sub_overflow(), 
    __builtin_add_overflow(), and __builtin_mul_overflow() 
   when available.
  * Added the SQLITE_ENABLE_NULL_TRIM compile-time option, which
    can result in significantly smaller database files for some
    applications, at the risk of being incompatible with older
    versions of SQLite.
  * Change SQLITE_DEFAULT_PCACHE_INITSZ from 100 to 20, for
    improved performance.
  * Added the SQLITE_UINT64_TYPE compile-time option as an analog
    to SQLITE_INT64_TYPE.
  * Perform some UPDATE operations in a single pass instead of in
    two passes.
  * Enhance the session extension to support WITHOUT ROWID tables.
  * Fixed performance problems and potential stack overflows when
    creating views from multi-row VALUES clauses with hundreds of
    thousands of rows.
  * Added the sha1.c extension.
  * In the command-line shell, enhance the ".mode" command so that
    it restores the default column and row separators for modes 
    "line", "list", "column", and "tcl".
  * Enhance the SQLITE_DIRECT_OVERFLOW_READ option so that it
    works in WAL mode as long as the pages being read are not
    in the WAL file.
buildservice-autocommit accepted request 449090 from Martin Pluskal's avatar Martin Pluskal (pluskalm) (revision 179) 
baserev update by copy to link target
Martin Pluskal's avatar Martin Pluskal (pluskalm) committed (revision 178) 
- Update to version 3.16.2:
Displaying revisions 141 - 160 of 337
openSUSE Build Service is sponsored by
Places