Overview Repositories Revisions Requests Users Attributes Meta

Revisions of sqlite3

Ismail Dönmez's avatar Ismail Dönmez (namtrac) committed (revision 177) 
- Update to version 3.16.1
  * Fix a bug concerning the use of row values within triggers
    (see ticket 8c9458e7) that was in version 3.15.0.
Martin Pluskal's avatar Martin Pluskal (pluskalm) committed (revision 176) 
- Update to version 3.16.0:
buildservice-autocommit accepted request 441301 from Ismail Dönmez's avatar Ismail Dönmez (namtrac) (revision 174) 
baserev update by copy to link target
buildservice-autocommit accepted request 435535 from Ismail Dönmez's avatar Ismail Dönmez (namtrac) (revision 172) 
baserev update by copy to link target
Ismail Dönmez's avatar Ismail Dönmez (namtrac) committed (revision 171) 
- 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.
buildservice-autocommit accepted request 427560 from Ismail Dönmez's avatar Ismail Dönmez (namtrac) (revision 170) 
baserev update by copy to link target
Ismail Dönmez's avatar Ismail Dönmez (namtrac) committed (revision 169) 
- 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:
buildservice-autocommit accepted request 419360 from Martin Pluskal's avatar Martin Pluskal (pluskalm) (revision 168) 
baserev update by copy to link target
Ismail Dönmez's avatar Ismail Dönmez (namtrac) committed (revision 166) 
-
Ismail Dönmez's avatar Ismail Dönmez (namtrac) committed (revision 165) 
- SQLite 3.14.0
  * Added support for WITHOUT ROWID virtual tables.
  * Improved the query planner so that the OR optimization can be
    used on virtual tables even if one or more of the disjuncts use
    the LIKE, GLOB, REGEXP, MATCH operators.
  * Added the CSV virtual table for reading RFC 4180 formatted
    comma-separated value files.
  * Added the carray() table-valued function extension.
  * Enabled persistent loadable extensions using the new
    SQLITE_OK_LOAD_PERMANENTLY return code from the extension entry point.
  * Added the SQLITE_DBSTATUS_CACHE_USED_SHARED option to sqlite3_db_status().
  * Add the vfsstat.c loadable extension - a VFS shim that measures
    I/O together with an eponymous virtual table that provides access to the measurements.
  * Improved algorithm for running queries with both an ORDER BY
    and a LIMIT where only the inner-most loop naturally generates rows in the correct order.
  * Enhancements to Lemon parser generator, so that it generates a faster parser.
  * The PRAGMA compile_options command now attempts to show the version number
    of the compiler that generated the library.
  * Enhance PRAGMA table_info so that it provides information about eponymous virtual tables.
  * The query planner uses a full scan of a partial index instead of a full scan
    of the main table, in cases where that makes sense.
  * Allow table-valued functions to appear on the right-hand side of an IN operator.
  * Added two new C-language interfaces: sqlite3_expanded_sql() and sqlite3_trace_v2().
    These new interfaces subsume the functions of sqlite3_trace() and sqlite3_profile()
    which are now deprecated.
  * Added the json_quote() SQL function to the json1 extension.
  * Disable the authorizer callback while reparsing the schema.
  * Added the SQLITE_ENABLE_UNKNOWN_SQL_FUNCTION compile-time option and
    turned that option on by default when building the command-line shell.
  * Fix the ALTER TABLE command so that it does not corrupt descending indexes when
buildservice-autocommit accepted request 416646 from Ismail Dönmez's avatar Ismail Dönmez (namtrac) (revision 164) 
baserev update by copy to link target
Ismail Dönmez's avatar Ismail Dönmez (namtrac) accepted request 416568 from Andreas Stieger's avatar Andreas Stieger (AndreasStieger) (revision 163) 
- Fix SLE 11 for previous change: noarch subpackages not supported
Martin Pluskal's avatar Martin Pluskal (pluskalm) accepted request 416551 from Tomáš Chvátal's avatar Tomáš Chvátal (scarabeus_iv) (revision 162) 
- Reduce the conditions a bit and sort with spec-cleaner
- Remove condition for old sle10 ppc machines
Ismail Dönmez's avatar Ismail Dönmez (namtrac) committed (revision 161) 
- SQLite 3.13.0:
  * Postpone I/O associated with TEMP files for as long as possible,
    with the hope that the I/O can ultimately be avoided completely.
  * Merged the session extension into trunk.
  * Added the ".auth ON|OFF" command to the command-line shell.
  * Added the "--indent" option to the ".schema" and ".fullschema"
    commands of the command-line shell, to turn on pretty-printing.
  * Added the ".eqp full" option to the command-line shell, that does
    both EXPLAIN and EXPLAIN QUERY PLAN on each statement that is evaluated.
  * Improved resistance against goofy query planner decisions caused by
    incomplete or incorrect modifications to the sqlite_stat1 table by
    the application.
  * Added the sqlite3_db_config(db,SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION)
    interface which allows the sqlite3_load_extension() C-API to be enabled
    while keeping the load_extension() SQL function disabled for security.
  * Change the temporary directory search algorithm on Unix to allow
    directories with write and execute permission, but without read permission,
    to serve as temporary directories. Apply this same standard to the "." fallback directory.
  * Fix a problem with the multi-row one-pass DELETE optimization that was
    causing it to compute incorrect answers with a self-referential subquery
    in the WHERE clause. Fix for ticket dc6ebeda9396087
  * Fix a possible segfault with DELETE when table is a rowid table with an
    INTEGER PRIMARY KEY and the WHERE clause contains a OR and the table has
    one or more indexes that are able to trigger the OR optimization, but none
    of the indexes reference any table columns other than the INTEGER PRIMARY KEY.
    Ticket 16c9801ceba49.
  * When checking for the WHERE-clause push-down optimization, verify that all
    terms of the compound inner SELECT are non-aggregate, not just the last term.
    Fix for ticket f7f8c97e97597.
buildservice-autocommit accepted request 390654 from Ismail Dönmez's avatar Ismail Dönmez (namtrac) (revision 160) 
baserev update by copy to link target
Ismail Dönmez's avatar Ismail Dönmez (namtrac) committed (revision 159) 
- 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.
buildservice-autocommit accepted request 386499 from Ismail Dönmez's avatar Ismail Dönmez (namtrac) (revision 158) 
baserev update by copy to link target
Displaying revisions 161 - 180 of 337
openSUSE Build Service is sponsored by
Places