2016-12-20 15:20:27 by Adam Ciarcinski | Files touched by this commit (3) |
Log message:
Add missing sqlite 3.15.2 commit
|
2016-12-04 06:17:46 by Ryo ONODERA | Files touched by this commit (667) |
Log message:
Recursive revbump from textproc/icu 58.1
|
2016-11-04 21:31:35 by Adam Ciarcinski | Files touched by this commit (5) |
Log message:
Changes 3.15.1:
* Added SQLITE_FCNTL_WIN32_GET_HANDLE file control opcode.
Bug Fixes:
* Fix the VACUUM command so that it spills excess content to disk rather than \
holding everything in memory, and possible causing an out-of-memory error for \
larger database files. This fixes an issue introduced by version 3.15.0.
* Fix a case (present since 3.8.0 - 2013-08-26) where OR-connected terms in the \
ON clause of a LEFT JOIN might cause incorrect results.
* Fix a case where the use of row values in the ON clause of a LEFT JOIN might \
cause incorrect results.
|
2016-10-22 01:32:40 by Kamil Rytarowski | Files touched by this commit (3) |
Log message:
Add sqlite3/Makefile.common for sqlite3 packages to share code
The intention is to reuse Makefile.common in devel/lemon.
Replace ${IS_BUILTIN.editline} == "yes" with \
!empty(IS_BUILTIN.editline:M[yY][eE][sS])
|
2016-10-17 14:17:50 by Adam Ciarcinski | Files touched by this commit (5) |
Log message:
Changes 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()).
Bug Fixes:
The multiply operator now correctly detects 64-bit integer overflow and promotes \
to floating point in all corner-cases.
Correct handling of columns with redundant unique indexes when those columns are \
used on the LHS of an IN operator.
Skip NULL entries on range queries in indexes on expressions.
Ensure that the AUTOINCREMENT counters in the sqlite_sequence table are \
initialized doing "Xfer Optimization" on "INSERT ... SELECT" \
statements.
Make sure the ORDER BY LIMIT optimization (from check-in 559733b09e) works with \
IN operators on INTEGER PRIMARY KEYs.
|
2016-09-13 12:48:24 by Adam Ciarcinski | Files touched by this commit (5) |
Log message:
SQLite Release 3.14.2:
* Improved support for using the STDCALL calling convention in winsqlite3.dll.
* 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.
* 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.
|
2016-08-14 13:19:09 by Adam Ciarcinski | Files touched by this commit (5) |
Log message:
Changes 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.
|
2016-08-09 16:54:26 by Adam Ciarcinski | Files touched by this commit (5) |
Log message:
Changes 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.
Added the "win32-none" VFS, analogous to the "unix-none" \
VFS, that works like the default "win32" VFS except that it ignores \
all file locks.
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.
Created the dbhash.exe command-line utility.
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.
Bug Fixes:
Fix the ALTER TABLE command so that it does not corrupt descending indexes when \
adding a column to a legacy file format database.
Fix a NULL-pointer dereference/crash that could occurs when a transitive WHERE \
clause references a non-existent collating sequence.
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.
|
2016-05-21 13:19:30 by Adam Ciarcinski | Files touched by this commit (6) |
Log message:
Release 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 unicode filename handling in the command-line shell on Windows.
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.
Bug Fixes:
----------
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.
Fix a locking race condition in Windows that can occur when two or more \
processes attempt to recover the same hot journal at the same time.
|
2016-04-20 07:04:44 by Adam Ciarcinski | Files touched by this commit (7) |
Log message:
Changes 3.12.2:
Fix a backwards compatibility problem in version 3.12.0 and 3.12.1: Columns \
declared as "INTEGER" PRIMARY KEY (with quotes around the datatype \
keyword) where not being recognized as an INTEGER PRIMARY KEY, which resulted in \
an incompatible database file.
Fix a bug (present since version 3.9.0) that can cause the DELETE operation to \
miss rows if PRAGMA reverse_unordered_selects is turned on.
Fix a bug in the code generator that can causes incorrect results if two or more \
virtual tables are joined and the virtual table used in outer loop of the join \
has an IN operator constraint.
Correctly interpret negative "PRAGMA cache_size" values when \
determining the cache size used for sorting large amounts of data.
|