Revisions of sqlite3

Dominique Leuenberger's avatar Dominique Leuenberger (dimstar_suse) accepted request 435535 from Ismail Dönmez's avatar Ismail Dönmez (namtrac) (revision 92)
- SQLite 3.15.0
  * Added support for row values.
  * Allow deterministic SQL functions in the WHERE clause of a
    partial index.
  * Added the "modeof=filename" URI parameter on the unix VFS
  * Added support for SQLITE_DBCONFIG_MAINDBNAME.
  * Added the ability to VACUUM an ATTACH-ed database.
  * Enhancements to the command-line shell:
    + Add the ".testcase" and ".check" dot-commands.
    + Added the --new option to the ".open" dot-command,
      causing any prior content in the database to be purged
      prior to opening.
  * Enhance the fts5vocab virtual table to handle "ORDER BY term"
    efficiently.
  * Miscellaneous micro-optimizations reduce CPU usage by more than
    7% on common workloads. Most optimization in this release
    has been on the front-end (sqlite3_prepare_v2()).
  * The multiply operator now correctly detects 64-bit
    integer overflow and promotes to floating point in all
    corner-cases. Fix for ticket 1ec41379c9c1e400.
  * Correct handling of columns with redundant unique indexes
    when those columns are used on the LHS of an IN operator.
    Fix for ticket 0eab1ac759.
  * Skip NULL entries on range queries in indexes on expressions.
    Fix for ticket 4baa46491212947.
  * Ensure that the AUTOINCREMENT counters in the sqlite_sequence
    table are initialized doing "Xfer Optimization" on 
    "INSERT ... SELECT" statements. Fix for ticket 7b3328086a5c116c.
  * Make sure the ORDER BY LIMIT optimization (from check-in 559733b09e)
    works with IN operators on INTEGER PRIMARY KEYs.
Dominique Leuenberger's avatar Dominique Leuenberger (dimstar_suse) accepted request 427560 from Ismail Dönmez's avatar Ismail Dönmez (namtrac) (revision 91)
- SQLite 3.14.2:
  * Fix the sqlite3_trace_v2() interface so that it is disabled
    if either the callback or the mask arguments are zero,
    in accordance with the documentation.
  * Fix commenting errors and improve the comments generated on
    EXPLAIN listings when the -DSQLITE_ENABLE_EXPLAIN_COMMENTS
    compile-time option is used.
  * Fix the ".read" command in the command-line shell so that
    it understands that its input is not interactive.
  * Correct affinity computations for a SELECT on the RHS of
    an IN operator. Fix for ticket 199df4168c.
  * The ORDER BY LIMIT optimization is not valid unless the
    inner-most IN operator loop is actually used by
    the query plan. Fix for ticket 0c4df46116e90f92.
  * Fix an internal code generator problem that was causing
    some DELETE operations to no-op. Ticket ef360601

- SQLite 3.14.1:
Dominique Leuenberger's avatar Dominique Leuenberger (dimstar_suse) accepted request 390654 from Ismail Dönmez's avatar Ismail Dönmez (namtrac) (revision 87)
- SQLite 3.12.2:
  * Fix compatibility with some legacy versions of sqlite database
  * Minor bugfixes

- SQLite 3.12.1:
  * Fix a boundary condition error introduced by version 3.12.0 that
    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.
Dominique Leuenberger's avatar Dominique Leuenberger (dimstar_suse) accepted request 386499 from Ismail Dönmez's avatar Ismail Dönmez (namtrac) (revision 86)
- Fix a boundary condition error introduced by version 3.12.0 that
  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.
Dominique Leuenberger's avatar Dominique Leuenberger (dimstar_suse) accepted request 381471 from Ismail Dönmez's avatar Ismail Dönmez (namtrac) (revision 85)
- 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
Dominique Leuenberger's avatar Dominique Leuenberger (dimstar_suse) accepted request 379566 from Ismail Dönmez's avatar Ismail Dönmez (namtrac) (revision 84)
- Enable secure delete by default, this matches Fedora & Android.
  It can be disabled with `PRAGMA SECURE_DELETE = 0;`
- Enable more extensions, syncing with Fedora & Gentoo.
Dominique Leuenberger's avatar Dominique Leuenberger (dimstar_suse) accepted request 367794 from Ismail Dönmez's avatar Ismail Dönmez (namtrac) (revision 83)
- 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
Displaying revisions 61 - 80 of 152
openSUSE Build Service is sponsored by