Accepting request 683700 from server:database
OBS-URL: https://build.opensuse.org/request/show/683700 OBS-URL: https://build.opensuse.org/package/show/openSUSE:Factory/sqlite3?expand=0&rev=112
This commit is contained in:
commit
b8ff1d52ec
@ -1,3 +0,0 @@
|
|||||||
version https://git-lfs.github.com/spec/v1
|
|
||||||
oid sha256:149e0dcdaa60602a003089461ecfe0c21b7d4469a5f4874f1480f364c869d531
|
|
||||||
size 9321276
|
|
3
sqlite-doc-3270200.zip
Normal file
3
sqlite-doc-3270200.zip
Normal file
@ -0,0 +1,3 @@
|
|||||||
|
version https://git-lfs.github.com/spec/v1
|
||||||
|
oid sha256:d84a42aaca5e8249a8e0725c1296add1b056ef8f58a52fbf916df89252c721d3
|
||||||
|
size 9371606
|
@ -1,3 +0,0 @@
|
|||||||
version https://git-lfs.github.com/spec/v1
|
|
||||||
oid sha256:e042825ba823d61db7edc45e52655c0434903a1b54bbe85a55880c9aa5884f7b
|
|
||||||
size 11939787
|
|
3
sqlite-src-3270200.zip
Normal file
3
sqlite-src-3270200.zip
Normal file
@ -0,0 +1,3 @@
|
|||||||
|
version https://git-lfs.github.com/spec/v1
|
||||||
|
oid sha256:15bd4286f2310f5fae085a1e03d9e6a5a0bb7373dcf8d4020868792e840fdf0a
|
||||||
|
size 12248529
|
@ -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
|
|
||||||
|
|
@ -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>
|
Thu Jan 17 16:58:54 UTC 2019 - Reinhard Max <max@suse.com>
|
||||||
|
|
||||||
|
10
sqlite3.spec
10
sqlite3.spec
@ -17,18 +17,17 @@
|
|||||||
|
|
||||||
|
|
||||||
%define oname sqlite
|
%define oname sqlite
|
||||||
%define tarversion 3260000
|
%define tarversion 3270200
|
||||||
Name: sqlite3
|
Name: sqlite3
|
||||||
Version: 3.26.0
|
Version: 3.27.2
|
||||||
Release: 0
|
Release: 0
|
||||||
Summary: Embeddable SQL Database Engine
|
Summary: Embeddable SQL Database Engine
|
||||||
License: SUSE-Public-Domain
|
License: SUSE-Public-Domain
|
||||||
Group: Productivity/Databases/Servers
|
Group: Productivity/Databases/Servers
|
||||||
URL: http://www.sqlite.org/
|
URL: http://www.sqlite.org/
|
||||||
Source0: http://www.sqlite.org/2018/sqlite-src-%{tarversion}.zip
|
Source0: http://www.sqlite.org/2019/sqlite-src-%{tarversion}.zip
|
||||||
Source1: baselibs.conf
|
Source1: baselibs.conf
|
||||||
Source2: http://www.sqlite.org/2018/sqlite-doc-%{tarversion}.zip
|
Source2: http://www.sqlite.org/2019/sqlite-doc-%{tarversion}.zip
|
||||||
Patch0: sqlite3-btree02-100.patch
|
|
||||||
BuildRequires: automake
|
BuildRequires: automake
|
||||||
BuildRequires: libtool
|
BuildRequires: libtool
|
||||||
BuildRequires: pkgconfig
|
BuildRequires: pkgconfig
|
||||||
@ -104,7 +103,6 @@ other documentation found on sqlite.org. The files can be found in
|
|||||||
|
|
||||||
%prep
|
%prep
|
||||||
%setup -q -n sqlite-src-%{tarversion} -a2
|
%setup -q -n sqlite-src-%{tarversion} -a2
|
||||||
%patch0
|
|
||||||
rm -v sqlite-doc-%{tarversion}/releaselog/current.html
|
rm -v sqlite-doc-%{tarversion}/releaselog/current.html
|
||||||
ln -sv `echo %{version} | sed "s/\./_/g"`.html 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
|
find -type f -name sqlite.css~ -delete
|
||||||
|
Loading…
Reference in New Issue
Block a user