From nw141292@sac.sfbay.sun.com Tue Jan 13 23:37:51 2009 Received: from sunmail3mpk.sfbay.sun.com (sunmail3mpk.SFBay.Sun.COM [129.146.11.52]) by sac.sfbay.sun.com (8.13.8+Sun/8.13.8) with ESMTP id n0E7bpic002482 for ; Tue, 13 Jan 2009 23:37:51 -0800 (PST) Received: from brm-avmta-1.central.sun.com (brm-avmta-1.Central.Sun.COM [129.147.4.11]) by sunmail3mpk.sfbay.sun.com (8.13.7+Sun/8.13.7/ENSMAIL,v2.2) with ESMTP id n0E7boji029304; Tue, 13 Jan 2009 23:37:51 -0800 (PST) Received: from pmxchannel-daemon.brm-avmta-1.central.sun.com by brm-avmta-1.central.sun.com (Sun Java System Messaging Server 6.2-3.04 (built Jul 15 2005)) id <0KDG00A0JAJ29700@brm-avmta-1.central.sun.com>; Wed, 14 Jan 2009 00:37:50 -0700 (MST) Received: from dm-sfbay-01.sfbay.sun.com ([129.145.155.118]) by brm-avmta-1.central.sun.com (Sun Java System Messaging Server 6.2-3.04 (built Jul 15 2005)) with ESMTP id <0KDG004DLAIYSRF0@brm-avmta-1.central.sun.com>; Wed, 14 Jan 2009 00:37:47 -0700 (MST) Received: from sac.sfbay.sun.com (new-sac.SFBay.Sun.COM [129.146.175.65]) by dm-sfbay-01.sfbay.sun.com (8.13.8+Sun/8.13.8/ENSMAIL,v2.2) with ESMTP id n0E7bjf7006365; Tue, 13 Jan 2009 23:37:45 -0800 (PST) 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 n0E7biVK002477; Tue, 13 Jan 2009 23:37:44 -0800 (PST) Received: (from nw141292@localhost) by sac.sfbay.sun.com (8.13.8+Sun/8.13.8/Submit) id n0E7biqA002473; Tue, 13 Jan 2009 23:37:44 -0800 (PST) Date: Tue, 13 Jan 2009 23:37:44 -0800 (PST) From: Nicolas Williams Subject: SQLite3 update to 3.6.9 [PSARC/2009/023 FastTrack timeout 01/21/2009] To: PSARC-ext@sun.com Cc: Alfred Peng , Brian Lu Message-id: <200901140737.n0E7biqA002473@sac.sfbay.sun.com> Content-transfer-encoding: 7BIT X-PMX-Version: 5.4.1.325704 Status: RO Content-Length: 2288 I'm sponsoring this fasttrack for myself. I request Minor release binding. SQLite3 3.5.4 was integrated as per PSARC/2008/120. This case updates SQLite3 in Solaris from version 3.5.4 to version 3.6.9 and enables some previously disabled features. COMPATIBILITY ------------- There are some incompatible changes, but none that are likely to cause any problems for Solaris users. The list of changes can be found here: http://sqlite.org/35to36.html http://sqlite.org/news.html http://sqlite.org/oldnews.html The incompatible API changes all relate to SQLite3's notion of "virtual filesystem," which is an interface used for abstracting operating system services that is not intended for use by SQLite3 applications as much as it is intended for developers on embedded systems. The only other relevant incompatible changes relate to improved SQL standard compliance and interoperability with other SQL engines: " 4 The way in which the IN and NOT IN operators handle NULL values in their right-hand expressions has been brought into compliance with the SQL standard and with other SQL database engines. 5 The column names for the result sets of SELECT statements have been tweaked in some cases to work more like other SQL database engines. " (These are described in detail at the first URL listed above.) I believe these incompatible changes are acceptable in a Minor release, as well as in OpenSolaris STS releases. The same rules for interface stability from the original ARC case (PSARC/2008/120) apply. NEW FEATURES ------------ The previously-disabled features being enabled are: - FTS3 (a full-text search extension that Firefox needs) - RTREE (a spatial index feature for spatial searches) The FTS3 and RTREE extensions are compiled into libsqlite3 -- there's no build option to make them runtime loadable extensions even though SQLite3 does have an optional feature for loading extensions at runtime. Documentation for the FTS3 and RTREE extensions can only be found in README files included in the source. These will be installed as: /usr/share/doc/sqlite3/ext/fts3/README.txt /usr/share/doc/sqlite3/ext/fts3/README.tokenizers /usr/share/doc/sqlite3/ext/rtree/README The HTML documentation in /usr/share/doc/sqlite3/ will also be updated. Nico -- From Nicolas.Williams@sun.com Thu Jan 15 08:27:13 2009 Received: from sunmail4.singapore.sun.com (sunmail4.Singapore.Sun.COM [129.158.71.19]) by sac.sfbay.sun.com (8.13.8+Sun/8.13.8) with ESMTP id n0FGRCkV020373 for ; Thu, 15 Jan 2009 08:27:13 -0800 (PST) Received: from nwk-avmta-2.sfbay.sun.com (nwk-avmta-2.SFBay.Sun.COM [129.145.155.6]) by sunmail4.singapore.sun.com (8.13.4+Sun/8.13.3/ENSMAIL,v2.2) with ESMTP id n0FGQvlC002646; Fri, 16 Jan 2009 00:27:11 +0800 (SGT) 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 <0KDI00B0DTP7GR00@nwk-avmta-2.sfbay.sun.com>; Thu, 15 Jan 2009 08:27:07 -0800 (PST) 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 <0KDI0059WTP7PG70@nwk-avmta-2.sfbay.sun.com>; Thu, 15 Jan 2009 08:27:07 -0800 (PST) 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 n0FGPx7q007251; Thu, 15 Jan 2009 10:25:59 -0600 (CST) Received: (from nw141292@localhost) by binky.Central.Sun.COM (8.14.3+Sun/8.14.3/Submit) id n0FGPx40007249; Thu, 15 Jan 2009 10:25:59 -0600 (CST) Date: Thu, 15 Jan 2009 10:25:59 -0600 From: Nicolas Williams Subject: Re: SQLite3 update to 3.6.9 [PSARC/2009/023 FastTrack timeout 01/21/2009] In-reply-to: <200901140737.n0E7biqA002473@sac.sfbay.sun.com> To: Nicolas Williams Cc: PSARC-ext@sun.com, Alfred Peng , Brian Lu Message-id: <20090115162559.GD884@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 References: <200901140737.n0E7biqA002473@sac.sfbay.sun.com> 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: 427 Some of the tests in SQLite3 3.6.9 fail on Solaris, and it's not clear why. Version 3.6.9 is a bugfix release for 3.6.8. Version 3.6.8 introduced some new optimizations and support for nested transactions, otherwise all interfaces in 3.6.7 and 3.6.8 are the same. Therefore I propose to integrate 3.6.7 first, and then upgrade to 3.6.9 or a follow-on (if no changes necessitate a trip to the ARC) at a later date. Nico -- From gdamore@sun.com Wed Jan 21 09:07:33 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 n0LH7W4a026604 for ; Wed, 21 Jan 2009 09:07:32 -0800 (PST) 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 n0LH7UgF022623 for <@sunmail2sca.sfbay.sun.com:PSARC-ext@sun.com>; Wed, 21 Jan 2009 17:07:31 GMT 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 <0KDT00I4XZKHMP00@nwk-avmta-2.sfbay.sun.com> for PSARC-ext@sun.com (ORCPT PSARC-ext@sun.com); Wed, 21 Jan 2009 09:07:29 -0800 (PST) Received: from sca-es-mail-1.sun.com ([192.18.43.132]) by nwk-avmta-2.sfbay.sun.com (Sun Java System Messaging Server 6.2-3.04 (built Jul 15 2005)) with ESMTP id <0KDT00DX5ZKGJQA0@nwk-avmta-2.sfbay.sun.com> for PSARC-ext@sun.com (ORCPT PSARC-ext@sun.com); Wed, 21 Jan 2009 09:07:28 -0800 (PST) Received: from fe-sfbay-09.sun.com ([192.18.43.129]) by sca-es-mail-1.sun.com (8.13.7+Sun/8.12.9) with ESMTP id n0LH7SBg013465 for ; Wed, 21 Jan 2009 09:07:28 -0800 (PST) Received: from conversion-daemon.fe-sfbay-09.sun.com by fe-sfbay-09.sun.com (Sun Java System Messaging Server 6.2-8.04 (built Feb 28 2007)) id <0KDT00F01YWME900@fe-sfbay-09.sun.com> (original mail from gdamore@sun.com) for PSARC-ext@sun.com (ORCPT PSARC-ext@sun.com); Wed, 21 Jan 2009 09:07:28 -0800 (PST) Received: from [10.7.251.172] by fe-sfbay-09.sun.com (Sun Java System Messaging Server 6.2-8.04 (built Feb 28 2007)) with ESMTPSA id <0KDT002ZKZKFZZB0@fe-sfbay-09.sun.com> for PSARC-ext@sun.com (ORCPT PSARC-ext@sun.com); Wed, 21 Jan 2009 09:07:27 -0800 (PST) Date: Wed, 21 Jan 2009 08:57:27 -0800 From: "Garrett D'Amore" Subject: PSARC 2009/023 SQLite3 update to 3.6.9 Sender: Garrett.Damore@sun.com To: PSARC-ext Message-id: <497753F7.9010608@sun.com> MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=ISO-8859-1 Content-transfer-encoding: 7BIT X-PMX-Version: 5.4.1.325704 User-Agent: Thunderbird 2.0.0.14 (X11/20080616) Status: RO Content-Length: 20 +1 -- Garrett From Nicolas.Williams@sun.com Wed Jan 21 10:14:18 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 n0LIEHnB013703 for ; Wed, 21 Jan 2009 10:14:18 -0800 (PST) Received: from nwk-avmta-1.SFBay.Sun.COM (nwk-avmta-1.SFBay.Sun.COM [129.146.11.74]) by newsunmail1brm.central.sun.com (8.13.7+Sun/8.13.7/ENSMAIL,v2.2) with ESMTP id n0LIEC5K000461; Wed, 21 Jan 2009 11:14:15 -0700 (MST) Received: from pmxchannel-daemon.nwk-avmta-1.sfbay.Sun.COM by nwk-avmta-1.sfbay.Sun.COM (Sun Java System Messaging Server 6.2-3.04 (built Jul 15 2005)) id <0KDU00D3X2NRYQ00@nwk-avmta-1.sfbay.Sun.COM>; Wed, 21 Jan 2009 10:14:15 -0800 (PST) Received: from binky.Central.Sun.COM ([129.153.128.104]) by nwk-avmta-1.sfbay.Sun.COM (Sun Java System Messaging Server 6.2-3.04 (built Jul 15 2005)) with ESMTP id <0KDU00A1Z2NQ35A0@nwk-avmta-1.sfbay.Sun.COM>; Wed, 21 Jan 2009 10:14:14 -0800 (PST) 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 n0LID2MQ025551; Wed, 21 Jan 2009 12:13:02 -0600 (CST) Received: (from nw141292@localhost) by binky.Central.Sun.COM (8.14.3+Sun/8.14.3/Submit) id n0LID2TW025550; Wed, 21 Jan 2009 12:13:02 -0600 (CST) Date: Wed, 21 Jan 2009 12:13:02 -0600 From: Nicolas Williams Subject: Re: SQLite3 update to 3.6.9 [PSARC/2009/023 FastTrack timeout 01/21/2009] In-reply-to: <200901140737.n0E7biqA002473@sac.sfbay.sun.com> To: Nicolas Williams Cc: PSARC-ext@sun.com, Alfred Peng , Brian Lu Message-id: <20090121181301.GA884@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 References: <200901140737.n0E7biqA002473@sac.sfbay.sun.com> 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: 144 This fasttrack was approved at today's PSARC meeting. I will send e-mail to the case to indicate which version is to be integrated in the end.