Next | Query returned 205 messages, browsing 111 to 120 | Previous

History of commit frequency

CVS Commit History:


   2016-04-11 21:02:08 by Ryo ONODERA | Files touched by this commit (527)
Log message:
Recursive revbump from textproc/icu 57.1
   2016-04-09 11:25:39 by Adam Ciarcinski | Files touched by this commit (5)
Log message:
Release 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.
   2016-04-08 09:54:27 by Adam Ciarcinski | Files touched by this commit (7)
Log message:
Release 3.12.0

Potentially Disruptive Change:
------------------------------
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. See the application note on the version 3.12.0 \ 
page size change for further information.

Performance enhancements:
-------------------------
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.
Only create statement journal files when their size exceeds a threshold. \ 
Otherwise the journal is held in memory and no I/O occurs. The threshold can be \ 
configured at compile-time using SQLITE_STMTJRNL_SPILL or at start-time using \ 
sqlite3_config(SQLITE_CONFIG_STMTJRNL_SPILL).
The query planner is able to optimize IN operators on virtual tables even if the \ 
xBestIndex method does not set the sqlite3_index_constraint_usage.omit flag of \ 
the virtual table column to the left of the IN operator.
The query planner now does a better job of optimizing virtual table accesses in \ 
a 3-way or higher join where constraints on the virtual table are split across \ 
two or more other tables of the join.
More efficient handling of application-defined SQL functions, especially in \ 
cases where the application defines hundreds or thousands of custom functions.
The query planner considers the LIMIT clause when estimating the cost of ORDER BY.
The configure script (on unix) automatically detects pread() and pwrite() and \ 
sets compile-time options to use those OS interfaces if they are available.
Reduce the amount of memory needed to hold the schema.
Other miscellaneous micro-optimizations for improved performance and reduced \ 
memory usage.

New Features:
-------------
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.

Bug fixes:
----------
Make sure the sqlite3_set_auxdata() values from multiple triggers within a \ 
single statement do not interfere with one another.
Fix the code generator for expressions of the form "x IN (SELECT...)" \ 
where the SELECT statement on the RHS is a correlated subquery.
Fix a harmless TSAN warning associated with the sqlite3_db_readonly() interface.
   2016-03-06 10:57:51 by Adam Ciarcinski | Files touched by this commit (6)
Log message:
Changes 3.11.1:
Improvements to the Makefiles and build scripts used by VisualStudio.
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.
   2016-02-20 11:25:02 by Jonathan Perkin | Files touched by this commit (1)
Log message:
Fix install_name on Darwin.  Bump PKGREVISION.
   2016-02-16 14:46:04 by Adam Ciarcinski | Files touched by this commit (5)
Log message:
Changes 3.11.0:

General improvements:

Enhanced WAL mode so that it works efficiently with transactions that are larger \ 
than the cache_size.
Added the FTS5 detail option.
Added the "EXTRA" option to PRAGMA synchronous that does a sync of the \ 
containing directory when a rollback journal is unlinked in DELETE mode, for \ 
better durability. The SQLITE_EXTRA_DURABLE compile-time option enables PRAGMA \ 
synchronous=EXTRA by default.
Enhanced the query planner so that it is able to use a covering index as part of \ 
the OR optimization.
Avoid recomputing NOT NULL and CHECK constraints on unchanged columns in UPDATE \ 
statement.
Many micro-optimizations, resulting in a library that is faster than the \ 
previous release.
Enhancements to the command-line shell:

By default, the shell is now in "auto-explain" mode. The output of \ 
EXPLAIN commands is automatically formatted.
Added the ".vfslist" dot-command.
The SQLITE_ENABLE_EXPLAIN_COMMENTS compile-time option is now turned on by \ 
default in the standard builds.

Enhancements to the TCL Interface:

If a database connection is opened with the "-uri 1" option, then URI \ 
filenames are honored by the "backup" and "restore" \ 
commands.
Added the "-sourceid" option to the "sqlite3" command.
Makefile improvements:

Improved pthreads detection in configure scripts.
Add the ability to do MSVC Windows builds from the amalgamation tarball.

Bug fixes

Fix an issue with incorrect sharing of VDBE temporary registers between \ 
co-routines that could cause incorrect query results in obscure cases. Ticket \ 
d06a25c84454a.
Fix a problem in the sqlite3_result_subtype() interface that could cause \ 
problems for the json1 extension under obscure circumstances. Fix for ticket \ 
f45ac567eaa9f9.
Escape control characters in JSON strings. Fix for ticket ad2559db380abf8.
Reenable the xCurrentTime and xGetLastError methods in the built-in unix VFSes \ 
as long as SQLITE_OMIT_DEPRECATED is not defined.

Backwards Compatibility:
Because of continuing security concerns, the two-argument version of of the \ 
seldom-used and little-known fts3_tokenizer() function is disabled unless SQLite \ 
is compiled with the SQLITE_ENABLE_FTS3_TOKENIZER.
   2016-01-24 11:39:45 by Adam Ciarcinski | Files touched by this commit (5)
Log message:
Changes 3.10.2:
* Version 3.10.0 introduced a case-folding bug in the LIKE operator which is \ 
fixed by this patch release.
* Fix a use-after-free that can occur when SQLite is compiled with \ 
-DSQLITE_HAS_CODEC.
* Fix the build so that it works with -DSQLITE_OMIT_WAL.
* Fix the configure script for the amalgamation so that the --readline option \ 
works again on Raspberry PIs.
   2016-01-16 19:10:23 by Adam Ciarcinski | Files touched by this commit (5)
Log message:
Changes 3.10.1:
* Add the SQLITE_FCNTL_JOURNAL_POINTER file control.
* Fix a 16-month-old bug in the query planner that could generate incorrect \ 
results when a scalar subquery attempts to use the block sorting optimization.
   2016-01-08 15:43:10 by Adam Ciarcinski | Files touched by this commit (9)
Log message:
Changes 3.10.0:

General improvements:
---------------------
Added support for LIKE, GLOB, and REGEXP operators on virtual tables.
Added the colUsed field to sqlite3_index_info for use by the \ 
sqlite3_module.xBestIndex method.
Enhance the PRAGMA cache_spill statement to accept a 32-bit integer parameter \ 
which is the threshold below which cache spilling is prohibited.
On unix, if a symlink to a database file is opened, then the corresponding \ 
journal files are based on the actual filename, not the symlink name.
Added the "--transaction" option to sqldiff.
Added the sqlite3_db_cacheflush() interface.
Added the sqlite3_strlike() interface.
When using memory-mapped I/O map the database file read-only so that stray \ 
pointers and/or array overruns in the application cannot accidently modify the \ 
database file.
Added the experimental sqlite3_snapshot_get(), sqlite3_snapshot_open(), and \ 
sqlite3_snapshot_free() interfaces. These are subject to change or removal in a \ 
subsequent release.
Enhance the 'utc' modifier in the date and time functions so that it is a no-op \ 
if the date/time is known to already be in UTC. (This is not a compatibility \ 
break since the behavior has long been documented as "undefined" in \ 
that case.)
Added the json_group_array() and json_group_object() SQL functions in the json \ 
extension.
Added the SQLITE_LIKE_DOESNT_MATCH_BLOBS compile-time option.
Many small performance optimizations.

Portability enhancements:
-------------------------
Work around a sign-exension bug in the optimizer of the HP C compiler on HP/UX. \ 
(details)

Enhancements to the command-line shell:
---------------------------------------
Added the ".changes ON|OFF" and ".vfsinfo" dot-commands.
Translate between MBCS and UTF8 when running in cmd.exe on Windows.

Enhancements to makefiles:
--------------------------
Added the --enable-editline and --enable-static-shell options to the various \ 
autoconf-generated configure scripts.
Omit all use of "awk" in the makefiles, to make building easier for \ 
MSVC users.

Important fixes:
----------------
Fix inconsistent integer to floating-point comparison operations that could \ 
result in a corrupt index if the index is created on a table column that \ 
contains both large integers and floating point values of similar magnitude. \ 
Ticket 38a97a87a6.
Fix an infinite-loop in the query planner that could occur on malformed common \ 
table expressions.
Various bug fixes in the sqldiff tool.
   2015-11-04 07:32:26 by Adam Ciarcinski | Files touched by this commit (5)
Log message:
Changes 3.9.2:
* Fix the schema parser so that it interprets certain (obscure and ill-formed) \ 
CREATE TABLE statements the same as legacy.
* Fix a query planner problem that could result in an incorrect answer due to \ 
the use of automatic indexing in subqueries in the FROM clause of a correlated \ 
scalar subqueries.

Next | Query returned 205 messages, browsing 111 to 120 | Previous