[arch-dev-public] [signoff] sqlite3 3.6.18-1

Andreas Radke 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 mailing list