Hello community, here is the log from the commit of package sqlite3 for openSUSE:Factory checked in at 2012-05-08 12:29:09 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Comparing /work/SRC/openSUSE:Factory/sqlite3 (Old) and /work/SRC/openSUSE:Factory/.sqlite3.new (New) ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Package is "sqlite3", Maintainer is "[email protected]" Changes: -------- --- /work/SRC/openSUSE:Factory/sqlite3/sqlite3.changes 2012-05-03 11:00:42.000000000 +0200 +++ /work/SRC/openSUSE:Factory/.sqlite3.new/sqlite3.changes 2012-05-08 12:29:11.000000000 +0200 @@ -1,0 +2,131 @@ +Fri May 4 06:49:49 UTC 2012 - [email protected] + +- Spec file cleanup +- Drop support for the pre 11.0 packaging scheme. +- New version 3.7.11. Changes since 3.7.8 include: + * Enhance the INSERT syntax to allow multiple rows to be inserted + via the VALUES clause. + * Enhance the CREATE VIRTUAL TABLE command to support the IF NOT + EXISTS clause. + * Added the sqlite3_stricmp() interface as a counterpart to + sqlite3_strnicmp(). + * Added the sqlite3_db_readonly() interface. + * Added the SQLITE_FCNTL_PRAGMA file control, giving VFS + implementations the ability to add new PRAGMA statements or to + override built-in PRAGMAs. + * Queries of the form: "SELECT max(x), y FROM table" returns the + value of y on the same row that contains the maximum x value. + * Added support for the FTS4 languageid option. + * Documented support for the FTS4 content option. This feature + has actually been in the code since version 3.7.9 but is only + now considered to be officially supported. + * Pending statements no longer block ROLLBACK. Instead, the + pending statement will return SQLITE_ABORT upon next access + after the ROLLBACK. + * Improvements to the handling of CSV inputs in the command-line + shell + * The default schema format number is changed from 1 to 4. This + means that, unless the PRAGMA legacy_file_format=ON statement + is run, newly created database files will be unreadable by + version of SQLite prior to 3.3.0 (2006-01-10). It also means + that the descending indices are enabled by default. + * The sqlite3_pcache_methods structure and the + SQLITE_CONFIG_PCACHE and SQLITE_CONFIG_GETPCACHE configuration + parameters are deprecated. They are replaced by a new + sqlite3_pcache_methods2 structure and SQLITE_CONFIG_PCACHE2 and + SQLITE_CONFIG_GETPCACHE2 configuration parameters. + * Added the powersafe overwrite property to the VFS + interface. Provide the SQLITE_IOCAP_POWERSAFE_OVERWRITE I/O + capability, the SQLITE_POWERSAFE_OVERWRITE compile-time option, + and the "psow=BOOLEAN" query parameter for URI filenames. + * Added the sqlite3_db_release_memory() interface and the + shrink_memory pragma. + * Added the sqlite3_db_filename() interface. + * Added the sqlite3_stmt_busy() interface. + * Added the sqlite3_uri_boolean() and sqlite3_uri_int64() + interfaces. + * If the argument to PRAGMA cache_size is negative N, that means + to use approximately -1024*N bytes of memory for the page cache + regardless of the page size. + * Enhanced the default memory allocator to make use of _msize() + on windows, malloc_size() on Mac, and malloc_usable_size() on + Linux. + * Enhanced the query planner to support index queries with range + constraints on the rowid. + * Enhanced the query planner flattening logic to allow UNION ALL + compounds to be promoted upwards to replace a simple wrapper + SELECT even if the compounds are joins. + * Enhanced the query planner so that the xfer optimization can be + used with INTEGER PRIMARY KEY ON CONFLICT as long as the + destination table is initially empty. + * Enhanced the windows VFS so that all system calls can be + overridden using the xSetSystemCall interface. + * Updated the "unix-dotfile" VFS to use locking directories with + mkdir() and rmdir() instead of locking files with open() and + unlink(). + * Enhancements to the test_quota.c extension to support + stdio-like interfaces with quotas. + * Change the unix VFS to be tolerant of read() system calls that + return less then the full number of requested bytes. + * Change both unix and windows VFSes to report a sector size of + 4096 instead of the old default of 512. + * In the TCL Interface, add the -uri option to the "sqlite3" TCL + command used for creating new database connection objects. + * Added the SQLITE_TESTCTRL_EXPLAIN_STMT test-control option with + the SQLITE_ENABLE_TREE_EXPLAIN compile-time option to enable + the command-line shell to display ASCII-art parse trees of SQL + statements that it processes, for debugging and analysis. + * Bug fix: Add an additional xSync when restarting a WAL in order + to prevent an exceedingly unlikely but theoretically possible + database corruption following power-loss. Ticket ff5be73dee. + * Bug fix: Change the VDBE so that all registers are initialized + to Invalid instead of NULL. Ticket 7bbfb7d442 + * Bug fix: Fix problems that can result from 32-bit integer + overflow. Ticket ac00f496b7e2 + * If a search token (on the right-hand side of the MATCH + operator) in FTS4 begins with "^" then that token must be the + first in its field of the document. ** Potentially Incompatible + Change ** + * Added options SQLITE_DBSTATUS_CACHE_HIT and + SQLITE_DBSTATUS_CACHE_MISS to the sqlite3_db_status() + interface. + * Removed support for SQLITE_ENABLE_STAT2, replacing it with the + much more capable SQLITE_ENABLE_STAT3 option. + * Enhancements to the sqlite3_analyzer utility program, including + the --pageinfo and --stats options and support for multiplexed + databases. + * Enhance the sqlite3_data_count() interface so that it can be + used to determine if SQLITE_DONE has been seen on the prepared + statement. + * Added the SQLITE_FCNTL_OVERWRITE file-control by which the + SQLite core indicates to the VFS that the current transaction + will overwrite the entire database file. + * Increase the default lookaside memory allocator allocation size + from 100 to 128 bytes. + * Enhanced the query planner so that it can factor terms in and + out of OR expressions in the WHERE clause in an effort to find + better indices. + * Added the SQLITE_DIRECT_OVERFLOW_READ compile-time option, + causing overflow pages to be read directly from the database + file, bypassing the page cache. + * Remove limits on the magnitude of precision and width value in + the format specifiers of the sqlite3_mprintf() family of string + rendering routines. + * Fix a bug that prevent ALTER TABLE ... RENAME from working on + some virtual tables in a database with a UTF16 encoding. + * Fix a bug in ASCII-to-float conversion that causes slow + performance and incorrect results when converting numbers with + ridiculously large exponents. + * Fix a bug that causes incorrect results in aggregate queries + that use multiple aggregate functions whose arguments contain + complicated expressions that differ only in the case of string + * literals contained within those expressions. + * Fix a bug that prevented the page_count and quick_check pragmas + from working correctly if their names were capitalized. + * Fix a bug that caused VACUUM to fail if the count_changes + pragma was engaged. + * Fix a bug in virtual table implementation that causes a crash + if an FTS4 table is dropped inside a transaction and a + SAVEPOINT occurs afterwards. + +------------------------------------------------------------------- @@ -9 +140 @@ -- New version 3.8: +- New version 3.7.8: Old: ---- sqlite-autoconf-3070800.tar.gz New: ---- sqlite-autoconf-3071100.tar.gz ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Other differences: ------------------ ++++++ sqlite3.spec ++++++ --- /var/tmp/diff_new_pack.UI3eJU/_old 2012-05-08 12:29:12.000000000 +0200 +++ /var/tmp/diff_new_pack.UI3eJU/_new 2012-05-08 12:29:12.000000000 +0200 @@ -1,7 +1,7 @@ # # spec file for package sqlite3 # -# Copyright (c) 2011 SUSE LINUX Products GmbH, Nuernberg, Germany. +# Copyright (c) 2012 SUSE LINUX Products GmbH, Nuernberg, Germany. # # All modifications and additions to the file contributed by third parties # remain the property of their copyright owners, unless otherwise agreed @@ -16,43 +16,36 @@ # -# -%if 0%{?suse_version} >= 1100 -# The package naming scheme changed starting with openSUSE 11.0 -%define newscheme 1 -%else -%define newscheme 0 -%endif - Name: sqlite3 -BuildRequires: pkg-config readline-devel tcl-devel -%if 0%{?suse_version} < 1100 -%define tcl_archdir %(echo 'puts [lindex $tcl_pkgPath 0]'|tclsh) -%endif -%if %{?suse_version:1}%{?!suse_version:0} -BuildRequires: update-desktop-files -%endif +Version: 3.7.11 +Release: 0 +%define tarversion 3071100 +Summary: Embeddable SQL Database Engine License: SUSE-Public-Domain Group: Productivity/Databases/Servers -Summary: Embeddable SQL Database Engine Url: http://www.sqlite.org/ -Version: 3.7.8 -Release: 1 -# %(IFS=.; a="%{version}"; printf "%d%02d%02d%02d" $a) -%define tarversion 3070800 -# bug437293 -%ifarch ppc64 -Obsoletes: sqlite-64bit +# +BuildRequires: pkg-config +BuildRequires: readline-devel +BuildRequires: tcl-devel +%if 0%{?suse_version:1} +BuildRequires: update-desktop-files %endif # -%if %newscheme Requires: libsqlite3-0 = %version -%endif Provides: sqlite = %version Obsoletes: sqlite < %version Source0: sqlite-autoconf-%tarversion.tar.gz Source1: baselibs.conf BuildRoot: %{_tmppath}/%{name}-%{version}-build +# bug437293 +%ifarch ppc64 +Obsoletes: sqlite-64bit +%endif +# +%if 0%{?suse_version} < 1100 +%define tcl_archdir %(echo 'puts [lindex $tcl_pkgPath 0]'|tclsh) +%endif %description SQLite is a C library that implements an embeddable SQL database @@ -66,10 +59,7 @@ SQLite can be used via the sqlite command line tool or via any application that supports the Qt database plug-ins. -%if %newscheme - %package -n libsqlite3-0 -License: SUSE-Public-Domain Summary: Shared libraries for the Embeddable SQL Database Engine Group: Development/Libraries/C and C++ @@ -88,13 +78,11 @@ SQLite can be used via the sqlite command line tool or via any application that supports the Qt database plug-ins. -%endif - %package devel -License: SUSE-Public-Domain -Group: Development/Libraries/C and C++ Summary: Embeddable SQL Database Engine -Requires: %name = %version glibc-devel +Group: Development/Libraries/C and C++ +Requires: glibc-devel +Requires: libsqlite3-0 = %version Provides: sqlite-devel = %version Obsoletes: sqlite-devel < %version @@ -111,9 +99,8 @@ application which supports the Qt database plug-ins. %package tcl -License: SUSE-Public-Domain -Group: Development/Libraries/Tcl Summary: Tcl binding for SQLite +Group: Development/Libraries/Tcl %description tcl This package contains laguage bindings from the Tcl programming @@ -141,28 +128,17 @@ cd tea make install DESTDIR=%buildroot libdir=%tcl_archdir -%if %newscheme - %post -n libsqlite3-0 -p /sbin/ldconfig %postun -n libsqlite3-0 -p /sbin/ldconfig -%else - -%post -p /sbin/ldconfig - -%postun -p /sbin/ldconfig -%endif %files %defattr(-,root,root) /usr/bin/sqlite3 %doc %_mandir/man1/* -# -%if %newscheme %files -n libsqlite3-0 %defattr(-,root,root) -%endif %_libdir/libsqlite*.so.* %files devel ++++++ sqlite-autoconf-3070800.tar.gz -> sqlite-autoconf-3071100.tar.gz ++++++ ++++ 32680 lines of diff (skipped) -- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
