Module Name:	pkgsrc
Committed By:	wiz
Date:		Thu Jun  7 19:49:11 UTC 2007

Modified Files:
	pkgsrc/databases/sqlite3: Makefile.common distinfo
	pkgsrc/databases/sqlite3/patches: patch-aa
Removed Files:
	pkgsrc/databases/sqlite3/patches: patch-ab

Log Message:
Update to 3.3.17:

2007 April 25 (3.3.17)

* When the "write_version" value of the database
  header is larger than what the library understands,
  make the database read-only instead of unreadable.
* Other minor bug fixes

2007 April 18 (3.3.16)

* Fix a bug that caused VACUUM to fail if NULLs
  appeared in a UNIQUE column.
* Reinstate performance improvements that were added
  in 3.3.14 but regressed in 3.3.15.
* Fix problems with the handling of ORDER BY expressions
  on compound SELECT statements in subqueries.
* Fix a potential segfault when destroying locks on
  WinCE in a multi-threaded environment.
* Documentation updates.

2007 April 9 (3.3.15)

* Fix a bug introduced in 3.3.14 that caused a rollback
  of CREATE TEMP TABLE to leave the database connection
  wedged.
* Fix a bug that caused an extra NULL row to be
  returned when a descending query was interrupted by
  a change to the database.
* The FOR EACH STATEMENT clause on a trigger now
  causes a syntax error. It used to be silently ignored.
* Fix an obscure and relatively harmless problem that
  might have caused a resource leak following an I/O
  error.
* Many improvements to the test suite. Test coverage
  now exceeded 98%

2007 April 2 (3.3.14)

* Fix a bug in 3.3.13 that could cause a segfault
  when the IN operator is used one one term of a
  two-column index and the right-hand side of the IN
  operator contains a NULL.
* Added a new OS interface method for determining
  the sector size of underlying media: sqlite3OsSectorSize().
* A new algorithm for statements of the form INSERT
  INTO table1 SELECT * FROM table2 is faster and
  reduces fragmentation. VACUUM uses statements of
  this form and thus runs faster and defragments
  better.
* Performance enhancements through reductions in disk I/O:
* Do not read the last page of an overflow chain
  when deleting the row - just add that page to
  the freelist.
* Do not store pages being deleted in the rollback journal.
* Do not read in the (meaningless) content of
  pages extracted from the freelist.
* Do not flush the page cache (and thus avoiding
  a cache refill) unless another process changes
  the underlying database file.
* Truncate rather than delete the rollback
  journal when committing a transaction in
  exclusive access mode, or when committing the
  TEMP database.
* Added support for exclusive access mode using
  "PRAGMA locking_mode=EXCLUSIVE"
* Use heap space instead of stack space for large
  buffers in the pager - useful on embedded platforms
  with stack-space limitations.
* Add a makefile target "sqlite3.c" that builds an
  amalgamation containing the core SQLite library C
  code in a single file.
* Get the library working correctly when compiled
  with GCC option "-fstrict-aliasing".
* Removed the vestigal SQLITE_PROTOCOL error.
* Improvements to test coverage, other minor bugs
  fixed, memory leaks plugged, code refactored and/or
  recommented in places for easier reading.


To generate a diff of this commit:
cvs rdiff -r1.11 -r1.12 pkgsrc/databases/sqlite3/Makefile.common
cvs rdiff -r1.10 -r1.11 pkgsrc/databases/sqlite3/distinfo
cvs rdiff -r1.1 -r1.2 pkgsrc/databases/sqlite3/patches/patch-aa
cvs rdiff -r1.1 -r0 pkgsrc/databases/sqlite3/patches/patch-ab

Please note that diffs are not public domain; they are subject to the
copyright notices on the relevant files.