SQLite version 3.6.19 is now available on the SQLite website
http://www.sqlite.org/
Version 3.6.19 adds support for enforcing foreign key constraints,
including support for deferred constraints and cascading deletes and
updates. Foreign key constraint enforcement is turned off by default
(for backwards compatibility) and must be enabled using a pragma:
PRAGMA foreign_keys=ON; Additional information at
http://www.sqlite.org/foreignkeys.html
Version 3.6.19 also generalizes the IS and IS NOT operators so that
they will take an arbitrary expression as their right-hand side
instead of just the literal NULL. You can still say "x IS NULL" and
it works as before. But you can now also say "x IS y" and the result
will be true if x=y or if both x and y are NULL.
This release has been extensively tested (we still have 100% branch
test coverage). We consider this release to be production ready.
Nevertheless, testing can only prove the presence of bugs, not their
absence. So if you encounter problems, please let us know.
D. Richard Hipp
d...@hwaci.com
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
