Subject: Upgrade SQLite3 to 3.6.14.2 [PSARC/2009/324 Self Review]
To:      PSARC-record@sac.sfbay.sun.com
Cc:      Brian.Lu@Sun.COM, Haixia.Wang@Sun.COM
Bcc:     sac-bar@sac.sfbay

I'm filing this automatic self-approved case on behalf of myself.

A new release of Firefox requires an upgrade of SQLite3 in Solaris,
specifically it requires 3.6.10 or higher.  I will update SQLite3 to
the current latest release, 3.6.14.2.

There are no backwards incompatible changes since 3.6.7 (the version
currently found in SFWNV).

New interfaces (text directly from, or adapted from the SQLite3
changelog, except where noted):

 o Added the optional asynchronous VFS module.

   NOTE: This feature will NOT be included in Solaris, as it consists of
   a source file that must be compiled into the application.

 o Added the sqlite3_unlock_notify() interface.

   Important: This interface is experimental and is subject to change
   without notice.

 o Added the reverse_unordered_selects pragma.

 o Add the new ".genfkey" command in the CLI for generating triggers to
   implement foreign key constraints.

 o Added the hot-backup interface.

 o Added new commands ".backup" and ".restore" to the CLI.

 o Added new methods backup and restore to the TCL interface.

 o Added support for nested transactions.

The changelog can be found here:

http://sqlite.org/changes.html

New function symbols exported by libsqlite3:

sqlite3_auto_extension
sqlite3_backup_finish
sqlite3_backup_init
sqlite3_backup_pagecount
sqlite3_backup_remaining
sqlite3_backup_step
sqlite3_config
sqlite3_context_db_handle
sqlite3_db_config
sqlite3_db_mutex
sqlite3_db_status
sqlite3_extended_errcode
sqlite3_initialize
sqlite3_limit
sqlite3_next_stmt
sqlite3_os_end
sqlite3_os_init
sqlite3_randomness
sqlite3_reset_auto_extension
sqlite3_result_error_code
sqlite3_shutdown
sqlite3_status
sqlite3_stmt_status
sqlite3_test_control

The documentation will be updated as well.

Nico
--