SQLite Release 3.3.5 On 2006 April 5 (3.3.5)

• CHECK constraints use conflict resolution algorithms correctly.
• The SUM() function throws an error on integer overflow.
• Choose the column names in a compound query from the left-most SELECT instead of the right-most.
• The sqlite3_create_collation() function honors the SQLITE_UTF16_ALIGNED flag.
• SQLITE_SECURE_DELETE compile-time option causes deletes to overwrite old data with zeros.
• Detect integer overflow in abs().
• The random() function provides 64 bits of randomness instead of only 32 bits.
• Parser detects and reports automaton stack overflow.
• Change the round() function to return REAL instead of TEXT.
• Allow WHERE clause terms on the left table of a LEFT OUTER JOIN to contain aggregate subqueries.
• Skip over leading spaces in text to numeric conversions.
• Various minor bug and documentation typo fixes and performance enhancements.

A complete list of SQLite releases in a single page is also available. A detailed history of every check-in is available at http://www.sqlite.org/src/timeline.