[arch-dev-public] [signoff] sqlite3 3.6.18-1
a.radke at arcor.de
Mon Sep 21 16:43:24 EDT 2009
New upstream release. I haven't added any of the new features. Will do
this by requests if needed later. Please signoff.
SQLite version 3.6.18 is now available for download from the SQLite
The SQLite source code is tracked and managed using the Fossil
distributed configuration management system. See
http://www.fossil-scm.org/ for further information on Fossil. SQLite
was previously versioned using CVS. The entire CVS history has been
imported into Fossil. The older CVS repository remains on the website
but is not read-only. There are two major enhancements in SQLite
version 3.6.18. The first is a series or refinements to the query
planner that help SQLite to choose better plans for joins where in the
past it was selecting suboptimal query plans. The SQLITE_ENABLE_STAT2
compile-time option has been added to cause SQLite to collect histogram
data on indices when the ANALYZE command is run. The use of
histograms improve the query planning performance even more.
The second major enhancement is that SQLite now support recursive
triggers. The older non-recursive behavior of triggers is still the
default behavior. Recursive triggers are activated using the
recursive_triggers pragma. In addition to allowing triggers to call
themselves (either directly or indirectly) the new capability also
fires DELETE triggers on rows that are removed from a table as a
result of REPLACE conflict resolution processing.
Non-recursive triggers are still the default behavior since this is
least likely to cause problems for existing applications. However, we
anticipate that triggers will become recursive by default beginning
with release 3.7.0. At that point, applications that want to continue
using the older non-recursive trigger behavior will need to use the
recursive_triggers pragma to disable recursive triggers.
This version of SQLite also contains bug fixes, though none of the
bugs are serious and all are obscure, so upgrading is optional.
The SQLite core continues to have 100% branch test coverage and so
despite the many changes in this release, the developers believe that
this version of SQLite is stable and ready for production use.
Please let me know if you encounter any problems.
D. Richard Hipp
drh at hwaci.com
More information about the arch-dev-public