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:

o      Do not read the last page of an overflow chain when deleting the row - just add that page to the freelist.

o      Do not store pages being deleted in the rollback journal.

o      Do not read in the (meaningless) content of pages extracted from the freelist.

o      Do not flush the page cache (and thus avoiding a cache refill) unless another process changes the underlying database file.

o      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.

 下载SQLite