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

SQLite 3.27.2

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

sqlite-doc-3260000.zip

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

sqlite-doc-3270200.zip

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

sqlite-src-3260000.zip

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

sqlite-src-3270200.zip

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

sqlite3-btree02-100.patch

@@ -1,55 +0,0 @@
-Index: test/btree02.test
-==================================================================
---- test/btree02.test
-+++ test/btree02.test
-@@ -19,36 +19,44 @@
- 
- load_static_extension db eval
- do_execsql_test btree02-100 {
-   CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID;
-   WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<10)
--    INSERT INTO t1(a,ax,b) SELECT printf('%02x',i), random(), i FROM c;
-+    INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c;
-   CREATE INDEX t1a ON t1(a);
-   CREATE TABLE t2(x,y);
-   CREATE TABLE t3(cnt);
-   WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4)
-     INSERT INTO t3(cnt) SELECT i FROM c;
-   SELECT count(*) FROM t1;
- } {10}
-+
-+proc showt1 {} {
-+  puts -nonewline "t1: "
-+  puts [db eval {SELECT printf('(%s,%s)',quote(a),quote(b)) FROM t1}]
-+}
-+
- do_test btree02-110 {
-   db eval BEGIN
-   set i 0
-+  # showt1
-   db eval {SELECT a, ax, b, cnt FROM t1 CROSS JOIN t3 WHERE b IS NOT NULL} {
--    if {$a==""} {set a 0}
--    if {$b==""} {set b 0}    
-+    if {$a==""} continue
-     db eval {INSERT INTO t2(x,y) VALUES($b,$cnt)}
-     # puts "a,b,cnt = ($a,$b,$cnt)"
-     incr i
-     if {$i%2==1} {
-       set bx [expr {$b+1000}]
--      # puts "INSERT ($a),$bx"
-+      #  puts "INSERT ($a),$bx"
-       db eval {INSERT INTO t1(a,ax,b) VALUES(printf('(%s)',$a),random(),$bx)}
-+      # showt1
-     } else {
-       # puts "DELETE a=$a"
-       db eval {DELETE FROM t1 WHERE a=$a}
-+      # showt1
-     }
-     db eval {COMMIT; BEGIN}
-   }  
-   db one {COMMIT; SELECT count(*) FROM t1;}
--} {27}
-+} {10}
- 
- finish_test
-

sqlite3.changes

@@ -1,3 +1,21 @@
+-------------------------------------------------------------------
+Sun Mar 10 17:37:06 UTC 2019 - Andreas Stieger <andreas.stieger@gmx.de>
+
+- SQLite 3.27.2:
+  * Add the VACUUM INTO command
+  * Issue an SQLITE_WARNING message on the error log if a
+    double-quoted string literal is used
+  * Add the remove_diacritics=2 option to FTS3 and FTS5.
+  * Add  the SQLITE_PREPARE_NO_VTAB option to sqlite3_prepare_v3().
+    Use that option to prevent circular references to shadow tables
+    from causing resource leaks.
+  * Enhancements to the sqlite3_deserialize() interface
+  * Enhancements to the CLI, mostly to support testing and debugging
+    of the SQLite library itself
+  * Increased robustness against malicious SQL that is run against
+    a maliciously corrupted database
+- drop sqlite3-btree02-100.patch
+  
 -------------------------------------------------------------------
 Thu Jan 17 16:58:54 UTC 2019 - Reinhard Max <max@suse.com>
 

sqlite3.spec

@@ -17,9 +17,9 @@
 
 
 %define oname sqlite
-%define tarversion 3260000
+%define tarversion 3270200
 Name:           sqlite3
-Version:        3.26.0
+Version:        3.27.2
 Release:        0
 Summary:        Embeddable SQL Database Engine
 License:        SUSE-Public-Domain
@@ -28,7 +28,6 @@ URL:            http://www.sqlite.org/
 Source0:        http://www.sqlite.org/2018/sqlite-src-%{tarversion}.zip
 Source1:        baselibs.conf
 Source2:        http://www.sqlite.org/2018/sqlite-doc-%{tarversion}.zip
-Patch0:         sqlite3-btree02-100.patch
 BuildRequires:  automake
 BuildRequires:  libtool
 BuildRequires:  pkgconfig
@@ -104,7 +103,6 @@ other documentation found on sqlite.org. The files can be found in
 
 %prep
 %setup -q -n sqlite-src-%{tarversion} -a2
-%patch0
 rm -v sqlite-doc-%{tarversion}/releaselog/current.html
 ln -sv `echo %{version} | sed "s/\./_/g"`.html sqlite-doc-%{tarversion}/releaselog/current.html
 find -type f -name sqlite.css~ -delete