|
|
|
|
@@ -1,3 +1,64 @@
|
|
|
|
|
-------------------------------------------------------------------
|
|
|
|
|
Sun Aug 14 07:26:23 UTC 2016 - astieger@suse.com
|
|
|
|
|
|
|
|
|
|
- SQlite 3.14.1:
|
|
|
|
|
* A performance enhancement to the page-cache "truncate"
|
|
|
|
|
operation reduces COMMIT time by dozens of milliseconds on
|
|
|
|
|
systems with a large page cache
|
|
|
|
|
* Fix to the --rbu option of sqldiff.
|
|
|
|
|
|
|
|
|
|
-------------------------------------------------------------------
|
|
|
|
|
Mon Aug 8 18:06:28 UTC 2016 - idonmez@suse.com
|
|
|
|
|
|
|
|
|
|
- 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 adding a column to a legacy file format database.
|
|
|
|
|
Ticket f68bf68513a1c15f
|
|
|
|
|
* Fix a NULL-pointer dereference/crash that could occurs when a
|
|
|
|
|
transitive WHERE clause references a non-existent collating
|
|
|
|
|
sequence. Ticket e8d439c77685eca6.
|
|
|
|
|
* Improved the cost estimation for an index scan which includes a WHERE
|
|
|
|
|
clause that can be partially or fully evaluated using columns in the index
|
|
|
|
|
and without having to do a table lookup. This fixes a performance regression
|
|
|
|
|
that occurred for some obscure queries following the ORDER BY LIMIT optimization
|
|
|
|
|
introduced in version 3.12.0.
|
|
|
|
|
|
|
|
|
|
-------------------------------------------------------------------
|
|
|
|
|
Tue Aug 2 13:41:17 UTC 2016 - astieger@suse.com
|
|
|
|
|
|
|
|
|
|
@@ -20,7 +81,8 @@ Wed May 18 19:43:17 UTC 2016 - idonmez@suse.com
|
|
|
|
|
* 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.
|
|
|
|
|
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.
|
|
|
|
|
@@ -28,16 +90,17 @@ Wed May 18 19:43:17 UTC 2016 - idonmez@suse.com
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
|
Git OBS Bridge