SQLite version 3.7.15 is now available on the SQLite website: http://www.sqlite.org/ (Dallas) http://www2.sqlite.org/ (New York mirror) http://www3.sqlite.org/ (Fremont California mirror)
This release of SQLite includes improvements to the query planner/optimizer. Perhaps the most notable of the several changes to the query planner is that it is now better able to exploit indices to implement ORDER BY even in cases where terms of the ORDER BY clause reference multiple tables in a join. Other changes in this release include: * Support for Windows Phone 8 * Added the INSTR() SQL function * Added the sqlite3_errstr() API function * Added the "PRAGMA busy_timeout" command A long standing bug involving COLLATE operators in CHECK constraints in shared-cache mode was located in fixed for this release. Because of this bug fix, upgrading to SQLite version 3.7.15 is recommended. Please send email to the sqlite-us...@sqlite.org mailing list, or directly to me, if you encounter any problems with this release. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-announce mailing list sqlite-announce@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-announce