- Spec file cleanup

- Drop support for the pre 11.0 packaging scheme.
- New version 3.7.11.

OBS-URL: https://build.opensuse.org/package/show/server:database/sqlite3?expand=0&rev=57

sqlite-autoconf-3070800.tar.gz

@@ -1,3 +0,0 @@
-version https://git-lfs.github.com/spec/v1
-oid sha256:fd8c7f70db7e06b51196efccb937f2a657abc7b27ef61fe3a7fb8e72ac4dfa32
-size 1776215

sqlite-autoconf-3071100.tar.gz

@@ -0,0 +1,3 @@
+version https://git-lfs.github.com/spec/v1
+oid sha256:2badc75dc536249bcd68c44d2a655724285d054303251eaff9d355194cb3476b
+size 1807754

sqlite3.changes

@@ -1,3 +1,134 @@
+-------------------------------------------------------------------
+Fri May  4 06:49:49 UTC 2012 - max@suse.com
+
+- 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.
+
 -------------------------------------------------------------------
 Thu Apr 26 22:04:07 UTC 2012 - behrisch@users.sourceforge.net
 
@@ -6,7 +137,7 @@ Thu Apr 26 22:04:07 UTC 2012 - behrisch@users.sourceforge.net
 -------------------------------------------------------------------
 Fri Oct  7 11:26:43 UTC 2011 - max@suse.com
 
-- New version 3.8:
+- New version 3.7.8:
   * Orders of magnitude performance improvement for CREATE INDEX on
     very large tables.
   * Improved the windows VFS to better defend against interference

sqlite3.spec

@@ -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
+Version:        3.7.11
-%if 0%{?suse_version} < 1100    
+Release:        0
-%define tcl_archdir %(echo 'puts [lindex $tcl_pkgPath 0]'|tclsh)  
+%define tarversion 3071100
-%endif
+Summary:        Embeddable SQL Database Engine
-%if %{?suse_version:1}%{?!suse_version:0}
-BuildRequires:  update-desktop-files
-%endif
 License:        SUSE-Public-Domain
 Group:          Productivity/Databases/Servers
-Summary:        Embeddable SQL Database Engine
 Url:            http://www.sqlite.org/
-Version:        3.7.8
+#
-Release:        1
+BuildRequires:  pkg-config
-# %(IFS=.; a="%{version}"; printf "%d%02d%02d%02d" $a)
+BuildRequires:  readline-devel
-%define tarversion 3070800
+BuildRequires:  tcl-devel
-# bug437293
+%if 0%{?suse_version:1}
-%ifarch ppc64
+BuildRequires:  update-desktop-files
-Obsoletes:      sqlite-64bit
 %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 @@ directly to and from the database files on disk.
 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 @@ directly to and from the database files on disk.
 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 @@ SQLite can be used via the sqlite command-line tool or via any
 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 @@ rm %buildroot/%_libdir/*.la
 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