Next | Query returned 205 messages, browsing 101 to 110 | Previous

History of commit frequency

CVS Commit History:


   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.

Next | Query returned 205 messages, browsing 101 to 110 | Previous