*** DRAFT ***

SQLite Release 3.3.5 On 2006-04-05

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

A complete list of SQLite releases in a single page and a chronology are both also available. A detailed history of every check-in is available at SQLite version control site.

*** DRAFT ***