Small. Fast. Reliable.
Choose any three.
SQLite Release 3.3.5 On 2006-04-05
- 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.