From sacadmin Thu May 28 13:03:31 2009 Received: from sac.sfbay.sun.com (localhost [127.0.0.1]) by sac.sfbay.sun.com (8.13.8+Sun/8.13.8) with ESMTP id n4SK3VJM008621; Thu, 28 May 2009 13:03:31 -0700 (PDT) Received: (from nw141292@localhost) by sac.sfbay.sun.com (8.13.8+Sun/8.13.8/Submit) id n4SK3UWp008617; Thu, 28 May 2009 13:03:31 -0700 (PDT) Date: Thu, 28 May 2009 13:03:31 -0700 (PDT) From: Nicolas Williams Message-Id: <200905282003.n4SK3UWp008617@sac.sfbay.sun.com> To: PSARC-record@sac.sfbay.sun.com Cc: Brian.Lu@Sun.COM, Haixia.Wang@Sun.COM Subject: Upgrade SQLite3 to 3.6.14.2 [PSARC/2009/324 Self Review] Status: RO Content-Length: 1769 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 -- From Nicolas.Williams@sun.com Thu May 28 15:02:03 2009 Received: from sunmail5.uk.sun.com (sunmail5.UK.Sun.COM [129.156.85.165]) by sac.sfbay.sun.com (8.13.8+Sun/8.13.8) with ESMTP id n4SM22EB012380 for ; Thu, 28 May 2009 15:02:03 -0700 (PDT) Received: from nwk-avmta-2.sfbay.sun.com (nwk-avmta-2.SFBay.Sun.COM [129.145.155.6]) by sunmail5.uk.sun.com (8.13.8+Sun/8.13.8/ENSMAIL,v2.2) with ESMTP id n4SM1tM3004164; Thu, 28 May 2009 23:01:59 +0100 (BST) Received: from pmxchannel-daemon.nwk-avmta-2.sfbay.sun.com by nwk-avmta-2.sfbay.sun.com (Sun Java System Messaging Server 6.2-3.04 (built Jul 15 2005)) id <0KKD0080PJVBW700@nwk-avmta-2.sfbay.sun.com>; Thu, 28 May 2009 15:01:59 -0700 (PDT) Received: from binky.Central.Sun.COM ([129.153.128.104]) by nwk-avmta-2.sfbay.sun.com (Sun Java System Messaging Server 6.2-3.04 (built Jul 15 2005)) with ESMTP id <0KKD006WTJVBC520@nwk-avmta-2.sfbay.sun.com>; Thu, 28 May 2009 15:01:59 -0700 (PDT) Received: from binky.Central.Sun.COM (localhost [127.0.0.1]) by binky.Central.Sun.COM (8.14.3+Sun/8.14.3) with ESMTP id n4SLxbfN014800; Thu, 28 May 2009 16:59:37 -0500 (CDT) Received: (from nw141292@localhost) by binky.Central.Sun.COM (8.14.3+Sun/8.14.3/Submit) id n4SLxb7R014799; Thu, 28 May 2009 16:59:37 -0500 (CDT) Date: Thu, 28 May 2009 16:59:37 -0500 From: Nicolas Williams Subject: Upgrade SQLite3 to 3.6.14.2 [PSARC/2009/324 Self Review] To: psarc-ext@sun.com Cc: Brian.Lu@sun.com, Haixia.Wang@sun.com Message-id: <20090528215937.GU29258@Sun.COM> MIME-version: 1.0 Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7BIT Content-disposition: inline X-PMX-Version: 5.4.1.325704 X-Authentication-warning: binky.Central.Sun.COM: nw141292 set sender to Nicolas.Williams@sun.com using -f User-Agent: Mutt/1.5.7i Status: RO Content-Length: 2256 [Note: I screwed up when running sac_nextcase such that this e-mail did not go out. I'm sending this manually. My apologies.] I'm filing this automatic self-approved case on behalf of myself. The release binging is patch/micro, with no intention to backport. 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). All new interfaces are Uncommitted, Volatile, or Obsolete Volatile as described in PSARC/2008/120. Namely: interfaces labeled as "experimental" in SQLite3 documentation are Volatile, ones labeled as "obsolete" in SQLite3 docs are Obsolete Volatile, and all others are Uncommitted. 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 -- From gdamore@sun.com Thu May 28 15:15:57 2009 Received: from newsunmail1brm.central.sun.com (newsunmail1brm.Central.Sun.COM [129.147.62.245]) by sac.sfbay.sun.com (8.13.8+Sun/8.13.8) with ESMTP id n4SMFvFv013179 for ; Thu, 28 May 2009 15:15:57 -0700 (PDT) Received: from nwk-avmta-2.sfbay.sun.com (nwk-avmta-2.SFBay.Sun.COM [129.145.155.6]) by newsunmail1brm.central.sun.com (8.13.7+Sun/8.13.7/ENSMAIL,v2.2) with ESMTP id n4SMFurQ032467 for <@sunmail2sca.sfbay.sun.com:psarc-ext@sun.com>; Thu, 28 May 2009 16:15:57 -0600 (MDT) Received: from pmxchannel-daemon.nwk-avmta-2.sfbay.sun.com by nwk-avmta-2.sfbay.sun.com (Sun Java System Messaging Server 6.2-3.04 (built Jul 15 2005)) id <0KKD00903KIHQ600@nwk-avmta-2.sfbay.sun.com> for psarc-ext@sun.com (ORCPT psarc-ext@sun.com); Thu, 28 May 2009 15:15:53 -0700 (PDT) Received: from sca-es-mail-2.sun.com ([192.18.43.133]) by nwk-avmta-2.sfbay.sun.com (Sun Java System Messaging Server 6.2-3.04 (built Jul 15 2005)) with ESMTP id <0KKD006NEKIGC340@nwk-avmta-2.sfbay.sun.com> for psarc-ext@sun.com (ORCPT psarc-ext@sun.com); Thu, 28 May 2009 15:15:52 -0700 (PDT) Received: from fe-sfbay-10.sun.com ([192.18.43.129]) by sca-es-mail-2.sun.com (8.13.7+Sun/8.12.9) with ESMTP id n4SMFqls008755 for ; Thu, 28 May 2009 15:15:52 -0700 (PDT) Received: from conversion-daemon.fe-sfbay-10.sun.com by fe-sfbay-10.sun.com (Sun Java(tm) System Messaging Server 7u2-7.02 64bit (built Apr 16 2009)) id <0KKD00M00K4JLP00@fe-sfbay-10.sun.com> for psarc-ext@sun.com (ORCPT psarc-ext@sun.com); Thu, 28 May 2009 15:15:52 -0700 (PDT) Received: from [192.168.251.11] ([unknown] [76.93.15.33]) by fe-sfbay-10.sun.com (Sun Java(tm) System Messaging Server 7u2-7.02 64bit (built Apr 16 2009)) with ESMTPSA id <0KKD00C26KIF2QD0@fe-sfbay-10.sun.com> for psarc-ext@sun.com (ORCPT psarc-ext@sun.com); Thu, 28 May 2009 15:15:52 -0700 (PDT) Date: Thu, 28 May 2009 15:15:51 -0700 From: "Garrett D'Amore" Subject: Re: Upgrade SQLite3 to 3.6.14.2 [PSARC/2009/324 Self Review] In-reply-to: <20090528215937.GU29258@Sun.COM> Sender: Garrett.Damore@sun.com To: Nicolas Williams Cc: psarc-ext@sun.com, Brian.Lu@sun.com, Haixia.Wang@sun.com Message-id: <4A1F0D17.5000903@sun.com> MIME-version: 1.0 Content-type: text/plain; CHARSET=US-ASCII; format=flowed Content-transfer-encoding: 7BIT X-PMX-Version: 5.4.1.325704 References: <20090528215937.GU29258@Sun.COM> User-Agent: Thunderbird 2.0.0.18 (X11/20081201) Status: RO Content-Length: 2438 +1 - Garrett Nicolas Williams wrote: > [Note: I screwed up when running sac_nextcase such that this e-mail did > not go out. I'm sending this manually. My apologies.] > > I'm filing this automatic self-approved case on behalf of myself. The > release binging is patch/micro, with no intention to backport. > > 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). > > All new interfaces are Uncommitted, Volatile, or Obsolete Volatile as > described in PSARC/2008/120. Namely: interfaces labeled as > "experimental" in SQLite3 documentation are Volatile, ones labeled as > "obsolete" in SQLite3 docs are Obsolete Volatile, and all others are > Uncommitted. > > 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 >