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 --
