SQLite Release 3.7.14

SQLite Release 3.7.14 On 2012-09-03 (3.7.14)

• Drop built-in support for OS/2. If you need to upgrade an OS/2 application to use this or a later version of SQLite, then add an application-defined VFS using the sqlite3_vfs_register() interface. The code removed in this release can serve as a baseline for the application-defined VFS.
  


• Ensure that floating point values are preserved exactly when reconstructing a database from the output of the ".dump" command of the command-line shell.
  


• Added the sqlite3_close_v2() interface.
  


• Updated the command-line shell so that it can be built using SQLITE_OMIT_FLOATING_POINT and SQLITE_OMIT_AUTOINIT.
  


• Improvements to the windows makefiles and build processes.
  


• Enhancements to PRAGMA integrity_check and PRAGMA quick_check so that they can optionally check just a single attached database instead of all attached databases.
  


• Enhancements to WAL mode processing that ensure that at least one valid read-mark is available at all times, so that read-only processes can always read the database.
  


• Performance enhancements in the sorter used by ORDER BY and CREATE INDEX.
  


• Added the SQLITE_DISABLE_FTS4_DEFERRED compile-time option.
  


• Better handling of aggregate queries where the aggregate functions are contained within subqueries.
  


• Enhance the query planner so that it will try to use a covering index on queries that make use of or optimization.
  


• SQLITE_SOURCE_ID: "2012-09-03 15:42:36 c0d89d4a9752922f9e367362366efde4f1b06f2a"
  


• SHA1 for sqlite3.c: 5fdf596b29bb426001f28b488ff356ae14d5a5a6
  

SQLite 3.7.14 Release Note<

Original Post : http://neodreamer-dev.tistory.com/679