Accepting request 614604 from home:AndreasStieger:branches:server:database

3.24.0

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

sqlite-autoconf-3230100.tar.gz

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

sqlite-autoconf-3240000.tar.gz

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

sqlite-doc-3230100.zip

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

sqlite-doc-3240000.zip

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

sqlite3.changes

@@ -1,3 +1,28 @@
+-------------------------------------------------------------------
+Wed Jun  6 16:22:50 UTC 2018 - astieger@suse.com
+
+- update to 3.24.0:
+  * Add support for PostgreSQL-style UPSERT
+  * Add support for auxiliary columns in r-tree tables
+  * Add C-language APIs for discovering SQL keywords used by SQLite
+  * Add C-language APIs for dynamic strings based on sqlite3_str
+  * Enhance ALTER TABLE so that it recognizes "true" and "false" as
+    valid arguments to DEFAULT
+  * Add the sorter-reference optimization as a compile-time option
+  * Improve the format of the EXPLAIN QUERY PLAN raw output, so that
+   it gives better information about the query plan and about the
+    relationships between the various components of the plan
+  * Added the SQLITE_DBCONFIG_RESET_DATABASE option to the
+    sqlite3_db_config() API.
+  * Automatically intercept the raw EXPLAIN QUERY PLAN output an
+    reformat it into an ASCII-art graph.
+  * Lines that begin with "#" and that are not in the middle of an
+    SQL statement are interpreted as comments
+  * Add the --append option to the ".backup" command
+  * Add the ".dbconfig" command
+  * various performance improvements
+  * various bug fixes
+
 -------------------------------------------------------------------
 Wed Apr 11 11:40:57 UTC 2018 - astieger@suse.com
 

sqlite3.spec

@@ -17,14 +17,14 @@
 
 
 %define oname sqlite
-%define tarversion 3230100
+%define tarversion 3240000
 Name:           sqlite3
-Version:        3.23.1
+Version:        3.24.0
 Release:        0
 Summary:        Embeddable SQL Database Engine
 License:        SUSE-Public-Domain
 Group:          Productivity/Databases/Servers
-Url:            http://www.sqlite.org/
+URL:            http://www.sqlite.org/
 Source0:        http://www.sqlite.org/2018/sqlite-autoconf-%{tarversion}.tar.gz
 Source1:        baselibs.conf
 Source2:        http://www.sqlite.org/2018/sqlite-doc-%{tarversion}.zip
@@ -38,7 +38,6 @@ BuildRequires:  unzip
 BuildRequires:  pkgconfig(zlib)
 Provides:       %{oname} = %{version}
 Obsoletes:      %{oname} < %{version}
-BuildRoot:      %{_tmppath}/%{name}-%{version}-build
 
 %description
 SQLite is a C library that implements an embeddable SQL database
@@ -142,23 +141,19 @@ find %{buildroot} -type f -name "*.la" -delete -print
 %postun -n libsqlite3-0 -p /sbin/ldconfig
 
 %files
-%defattr(-,root,root)
 %{_bindir}/sqlite3
-%{_mandir}/man1/sqlite3.1%{ext_man}
+%{_mandir}/man1/sqlite3.1%{?ext_man}
 
 %files -n libsqlite3-0
-%defattr(-,root,root)
 %{_libdir}/libsqlite3.so.*
 
 %files devel
-%defattr(-,root,root)
 %{_includedir}/sqlite3.h
 %{_includedir}/sqlite3ext.h
 %{_libdir}/libsqlite3.so
 %{_libdir}/pkgconfig/sqlite3.pc
 
 %files doc
-%defattr(-,root,root)
 %doc sqlite-doc-%{tarversion}/*
 
 %changelog