Accepting request 352457 from server:database

1

OBS-URL: https://build.opensuse.org/request/show/352457
OBS-URL: https://build.opensuse.org/package/show/openSUSE:Factory/sqlite3?expand=0&rev=80

sqlite-autoconf-3090200.tar.gz

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

sqlite-autoconf-3100000.tar.gz

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

sqlite-doc-3090200.zip

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

sqlite-doc-3100000.zip

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

sqlite3.changes

@@ -1,3 +1,41 @@
+-------------------------------------------------------------------
+Thu Jan  7 12:49:58 UTC 2016 - mimi.vx@gmail.com
+
+- update to 3.10.0
+- spec-cleaned
+* Added support for LIKE, GLOB, and REGEXP operators on virtual tables.
+* Added the colUsed field to sqlite3_index_info for use by the 
+	sqlite3_module.xBestIndex method.
+* Enhance the PRAGMA cache_spill statement to accept a 32-bit integer parameter 
+	which is the threshold below which cache spilling is prohibited.
+* On unix, if a symlink to a database file is opened, then the corresponding 
+	journal files are based on the actual filename, not the symlink name.
+* Added the "--transaction" option to sqldiff.
+* Added the sqlite3_db_cacheflush() interface.
+* Added the sqlite3_strlike() interface.
+* When using memory-mapped I/O map the database file read-only so that stray 
+	pointers and/or array overruns in the application cannot accidently modify
+	the database file.
+* Added the experimental sqlite3_snapshot_get(), sqlite3_snapshot_open(), and 
+	sqlite3_snapshot_free() interfaces. These are subject to change or removal in
+	a subsequent release.
+* Enhance the 'utc' modifier in the date and time functions so that it is a no-op 
+	if the date/time is known to already be in UTC. (This is not a compatibility 
+	break since the behavior has long been documented as "undefined" in that case.)
+* Added the json_group_array() and json_group_object() SQL functions in the json
+	 extension.
+* Added the SQLITE_LIKE_DOESNT_MATCH_BLOBS compile-time option.
+* Many small performance optimizations.
++ Enhancements to the command-line shell:
+ * Added the ".changes ON|OFF" and ".vfsinfo" dot-commands.
++ Important fixes:
+ * Fix inconsistent integer to floating-point comparison operations that could 
+	result in a corrupt index if the index is created on a table column that 
+	contains both large integers and floating point values of similar magnitude.
+ * Fix an infinite-loop in the query planner that could occur on malformed common 
+	table expressions.
+ * Various bug fixes in the sqldiff tool.
+
 -------------------------------------------------------------------
 Mon Nov  2 20:51:40 UTC 2015 - astieger@suse.com
 

sqlite3.spec

@@ -1,7 +1,7 @@
 #
 # spec file for package sqlite3
 #
-# Copyright (c) 2015 SUSE LINUX GmbH, Nuernberg, Germany.
+# Copyright (c) 2016 SUSE LINUX GmbH, Nuernberg, Germany.
 #
 # All modifications and additions to the file contributed by third parties
 # remain the property of their copyright owners, unless otherwise agreed
@@ -19,30 +19,29 @@
 # Simplify building on RH for Application:Geo (SR#212812).
 %define pname sqlite3
 %define oname sqlite
-
+%define tarversion 3100000
-Name:           %pname
+Name:           %{pname}
-Version:        3.9.2
+Version:        3.10.0
 Release:        0
-%define tarversion 3090200
 Summary:        Embeddable SQL Database Engine
 License:        SUSE-Public-Domain
 Group:          Productivity/Databases/Servers
 Url:            http://www.sqlite.org/
+Source0:        http://www.sqlite.org/2016/sqlite-autoconf-%{tarversion}.tar.gz
+Source1:        baselibs.conf
+Source2:        http://www.sqlite.org/2016/sqlite-doc-%{tarversion}.zip
 #
 BuildRequires:  pkg-config
 BuildRequires:  readline-devel
 BuildRequires:  unzip
+#
+Requires:       libsqlite3-0 = %{version}
+Provides:       %{oname} = %{version}
+Obsoletes:      %{oname} < %{version}
+BuildRoot:      %{_tmppath}/%{name}-%{version}-build
 %if 0%{?suse_version:1}
 BuildRequires:  update-desktop-files
 %endif
-#
-Requires:       libsqlite3-0 = %version
-Provides:       %oname = %version
-Obsoletes:      %oname < %version
-Source0:        http://www.sqlite.org/2015/sqlite-autoconf-%tarversion.tar.gz
-Source1:        baselibs.conf
-Source2:        http://www.sqlite.org/2015/sqlite-doc-%tarversion.zip
-BuildRoot:      %{_tmppath}/%{name}-%{version}-build
 # bug437293
 %ifarch ppc64
 Obsoletes:      sqlite-64bit < %{version}
@@ -63,7 +62,6 @@ SQLite can be used via the sqlite command line tool or via any
 application that supports the Qt database plug-ins.
 
 %package -n libsqlite3-0
-
 Summary:        Shared libraries for the Embeddable SQL Database Engine
 Group:          Development/Libraries/C and C++
 
@@ -83,14 +81,13 @@ SQLite can be used via the sqlite command line tool or via any
 application that supports the Qt database plug-ins.
 
 %package devel
-
 Summary:        Embeddable SQL Database Engine
 Group:          Development/Libraries/C and C++
 Requires:       glibc-devel
-Requires:       libsqlite3-0 = %version
+Requires:       libsqlite3-0 = %{version}
-Provides:       %oname-devel = %version
+Suggests:       %{name}-doc
-Obsoletes:      %oname-devel < %version
+Provides:       %{oname}-devel = %{version}
-Suggests:       %name-doc
+Obsoletes:      %{oname}-devel < %{version}
 
 %description devel
 SQLite is a C library that implements an embeddable SQL database
@@ -105,8 +102,7 @@ SQLite can be used via the sqlite command-line tool or via any
 application which supports the Qt database plug-ins.
 
 %package doc
-
+Summary:        Documentation for %{name}
-Summary:        Documentation for %name
 Group:          Documentation
 %if 0%{?suse_version} >= 1130
 BuildArch:      noarch
@@ -116,26 +112,26 @@ BuildArch:      noarch
 
 Contains HTML documentation for SQLite: SQL Syntax, C/C++ API and
 other documentation found on sqlite.org. The files can be found in
-%_docdir/%name-doc.
+%{_docdir}/%{name}-doc.
 
 %prep
-%setup -q -n sqlite-autoconf-%tarversion -a2
+%setup -q -n sqlite-autoconf-%{tarversion} -a2
 rm -v sqlite-doc-%{tarversion}/releaselog/current.html
 ln -sv `echo %{version} | sed "s/\./_/g"`.html sqlite-doc-%{tarversion}/releaselog/current.html
 
 %build
-export CFLAGS="%optflags \
+export CFLAGS="%{optflags} \
 	-DSQLITE_ENABLE_COLUMN_METADATA \
 	-DSQLITE_ENABLE_FTS4 \
 	-DSQLITE_ENABLE_UNLOCK_NOTIFY \
 	-DSQLITE_ENABLE_JSON1 \
 	"
 %configure --disable-static
-make
+make 
 
 %install
-make install DESTDIR=%buildroot
+make DESTDIR=%{buildroot} install %{?_smp_mflags}
-rm %buildroot/%_libdir/*.la
+find %{buildroot} -type f -name "*.la" -delete -print
 
 %post -n libsqlite3-0 -p /sbin/ldconfig
 
@@ -143,21 +139,21 @@ rm %buildroot/%_libdir/*.la
 
 %files
 %defattr(-,root,root)
-/usr/bin/sqlite3
+%{_bindir}/sqlite3
-%doc %_mandir/man1/*
+%{_mandir}/man1/*
 
 %files -n libsqlite3-0
 %defattr(-,root,root)
-%_libdir/libsqlite*.so.*
+%{_libdir}/libsqlite*.so.*
 
 %files devel
 %defattr(-,root,root)
-/usr/include/*.h
+%{_includedir}/*.h
-%_libdir/libsqlite*.so
+%{_libdir}/libsqlite*.so
-%_libdir/pkgconfig/sqlite3.pc
+%{_libdir}/pkgconfig/sqlite3.pc
 
 %files doc
 %defattr(-,root,root)
-%doc sqlite-doc-%tarversion/*
+%doc sqlite-doc-%{tarversion}/*
 
 %changelog