- Update to release 3.46.1:

* Improved robustness while parsing the tokenize= arguments in
    FTS5.
  * Enhancements to covering index prediction in the query planner.
  * Do not let the number of terms on a VALUES clause be limited by
    SQLITE_LIMIT_COMPOUND_SELECT, even if the VALUES clause
    contains elements that appear to be variables due to
    double-quoted string literals.
  * Fix the window function version of group_concat() so that it
    returns an empty string if it has one or more empty string
    inputs.
  * In FTS5 secure-delete mode, fix false-positive integrity-check
    reports about corrupt indexes.
  * Syntax errors in ALTER TABLE should always return SQLITE_ERROR.
    In some cases, they were formerly returning SQLITE_INTERNAL.
  * Other minor fixes.

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

.gitattributes

@@ -0,0 +1,23 @@
+## Default LFS
+*.7z filter=lfs diff=lfs merge=lfs -text
+*.bsp filter=lfs diff=lfs merge=lfs -text
+*.bz2 filter=lfs diff=lfs merge=lfs -text
+*.gem filter=lfs diff=lfs merge=lfs -text
+*.gz filter=lfs diff=lfs merge=lfs -text
+*.jar filter=lfs diff=lfs merge=lfs -text
+*.lz filter=lfs diff=lfs merge=lfs -text
+*.lzma filter=lfs diff=lfs merge=lfs -text
+*.obscpio filter=lfs diff=lfs merge=lfs -text
+*.oxt filter=lfs diff=lfs merge=lfs -text
+*.pdf filter=lfs diff=lfs merge=lfs -text
+*.png filter=lfs diff=lfs merge=lfs -text
+*.rpm filter=lfs diff=lfs merge=lfs -text
+*.tbz filter=lfs diff=lfs merge=lfs -text
+*.tbz2 filter=lfs diff=lfs merge=lfs -text
+*.tgz filter=lfs diff=lfs merge=lfs -text
+*.ttf filter=lfs diff=lfs merge=lfs -text
+*.txz filter=lfs diff=lfs merge=lfs -text
+*.whl filter=lfs diff=lfs merge=lfs -text
+*.xz filter=lfs diff=lfs merge=lfs -text
+*.zip filter=lfs diff=lfs merge=lfs -text
+*.zst filter=lfs diff=lfs merge=lfs -text

.gitignore

@@ -0,0 +1 @@
+.osc

baselibs.conf

@@ -0,0 +1,3 @@
+libsqlite3-0
+  obsoletes "sqlite-<targettype> <= <version>"
+  provides "sqlite-<targettype> = <version>"

sqlite-doc-3460000.zip

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

sqlite-doc-3460100.zip

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

sqlite-src-3460000.zip

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

sqlite-src-3460100.zip

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

sqlite3.spec

@@ -0,0 +1,218 @@
+#
+# spec file for package sqlite3
+#
+# Copyright (c) 2024 SUSE LLC
+#
+# All modifications and additions to the file contributed by third parties
+# remain the property of their copyright owners, unless otherwise agreed
+# upon. The license for this file, and modifications and additions to the
+# file, is the same license as for the pristine package itself (unless the
+# license for the pristine package is not an Open Source License, in which
+# case the license is the MIT License). An "Open Source License" is a
+# license that conforms to the Open Source Definition (Version 1.9)
+# published by the Open Source Initiative.
+
+# Please submit bugfixes or comments via https://bugs.opensuse.org/
+#
+
+
+%define oname sqlite
+%define tarversion 3460100
+%define docversion 3460100
+%bcond_with icu
+%bcond_without check
+Name:           sqlite3
+Version:        3.46.1
+Release:        0
+Summary:        Embeddable SQL Database Engine
+License:        SUSE-Public-Domain
+Group:          Productivity/Databases/Servers
+URL:            https://www.sqlite.org/
+Source0:        https://www.sqlite.org/2023/sqlite-src-%{tarversion}.zip
+Source1:        baselibs.conf
+Source2:        https://www.sqlite.org/2023/sqlite-doc-%{docversion}.zip
+BuildRequires:  automake
+BuildRequires:  libtool
+BuildRequires:  pkgconfig
+BuildRequires:  readline-devel
+BuildRequires:  tcl-devel
+BuildRequires:  unzip
+%if 0%{suse_version} < 1500
+# As of 2021 we still need to be able to compile this on SLE-12
+BuildRoot:      %{_tmppath}/%{name}-%{version}-build
+BuildRequires:  zlib-devel
+%global make_build make
+%else
+BuildRequires:  pkgconfig(zlib)
+%endif
+Provides:       %{oname} = %{version}
+Obsoletes:      %{oname} < %{version}
+%if %{with icu}
+BuildRequires:  libicu-devel
+%endif
+%{?suse_build_hwcaps_libs}
+
+%description
+SQLite is a C library that implements an embeddable SQL database
+engine. Programs that link with the SQLite library can have SQL
+database access without running a separate RDBMS process.
+
+SQLite is not a client library used to connect to a big database
+server. SQLite is a server and the SQLite library reads and writes
+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.
+
+%package -n libsqlite3-0
+Summary:        Shared libraries for the Embeddable SQL Database Engine
+Group:          Development/Libraries/C and C++
+
+%description -n libsqlite3-0
+This package contains the shared libraries for the Embeddable SQL
+Database Engine.
+
+SQLite is a C library that implements an embeddable SQL database
+engine. Programs that link with the SQLite library can have SQL
+database access without running a separate RDBMS process.
+
+SQLite is not a client library used to connect to a big database
+server. SQLite is a server and the SQLite library reads and writes
+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.
+
+%package devel
+Summary:        Embeddable SQL Database Engine
+Group:          Development/Libraries/C and C++
+Requires:       glibc-devel
+Requires:       libsqlite3-0 = %{version}
+Suggests:       %{name}-doc
+Provides:       %{oname}-devel = %{version}
+Obsoletes:      %{oname}-devel < %{version}
+
+%description devel
+SQLite is a C library that implements an embeddable SQL database
+engine. Programs that link with the SQLite library can have SQL
+database access without running a separate RDBMS process.
+
+SQLite is not a client library used to connect to a big database
+server; SQLite is the server. The SQLite library reads and writes
+directly to and from the database files on disk.
+
+SQLite can be used via the sqlite command-line tool or via any
+application which supports the Qt database plug-ins.
+
+%package tcl
+Summary:        Tcl binding for SQLite
+Group:          Development/Libraries/Tcl
+
+%description tcl
+This package contains laguage bindings from the Tcl programming
+language SQLite.
+
+SQLite is a C library that implements an embeddable SQL database
+engine. Programs that link with the SQLite library can have SQL
+database access without running a separate RDBMS process.
+
+%package doc
+Summary:        Documentation for %{name}
+Group:          Documentation/Other
+BuildArch:      noarch
+
+%description doc
+
+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.
+
+%prep
+# Version and %tarversion need to match, but %docversion might be different,
+IFS=. read a b c d <<< "%version"
+if [ "%tarversion" != $(printf "%1d%02d%02d%02d" $a $b $c $d) ]
+then
+	echo "Version %version does not match tarversion %tarversion."
+	exit 1
+fi
+
+%autosetup -p0 -n sqlite-src-%{tarversion} -a2
+
+rm -v sqlite-doc-%{docversion}/releaselog/current.html
+ln -sv `echo %{docversion} | sed "s/\./_/g"`.html sqlite-doc-%{docversion}/releaselog/current.html
+find -type f -name sqlite.css~ -delete
+cmp sqlite-doc-%{docversion}/fileformat{,2}.html && ln -sf fileformat.html sqlite-doc-%{docversion}/fileformat2.html
+
+%build
+export TCLLIBDIR=%tcl_archdir/sqlite%version
+export LIBS="$LIBS -lm %{?with_icu:-licuuc -licui18n}"
+export CFLAGS="%{optflags} \
+	-DSQLITE_ENABLE_API_ARMOR \
+	-DSQLITE_ENABLE_COLUMN_METADATA \
+	-DSQLITE_ENABLE_DBSTAT_VTAB \
+	-DSQLITE_ENABLE_HIDDEN_COLUMNS \
+	-DSQLITE_ENABLE_FTS3 \
+	-DSQLITE_ENABLE_FTS4 \
+	-DSQLITE_ENABLE_FTS5 \
+%if %{with icu}
+	-DSQLITE_ENABLE_ICU \
+%endif
+	-DSQLITE_ENABLE_JSON1 \
+	-DSQLITE_ENABLE_RBU \
+	-DSQLITE_ENABLE_RTREE \
+	-DSQLITE_ENABLE_UPDATE_DELETE_LIMIT \
+	-DSQLITE_SOUNDEX \
+	-DSQLITE_ENABLE_UNLOCK_NOTIFY \
+	-DSQLITE_SECURE_DELETE \
+	-DSQLITE_ENABLE_MATH_FUNCTIONS \
+	-DSQLITE_STRICT_SUBTYPE=1 \
+	"
+%configure \
+  --disable-static \
+  --enable-readline \
+  --enable-fts3 \
+  --enable-fts4 \
+  --enable-fts5 \
+  --enable-update-limit \
+  --enable-rtree
+%make_build sqlite3.c
+%make_build
+
+%if %{with check}
+%check
+%make_build test
+%endif
+
+%install
+%make_install
+#mkdir -p %{buildroot}/%{_mandir}/man{1,n}/
+install -Dp -m 0644 -t %{buildroot}/%{_mandir}/man1 sqlite3.1
+install -Dp -m 0644 -t %{buildroot}/%{_mandir}/mann autoconf/tea/doc/sqlite3.n
+# tcl bindings are provided by tcl itself
+#rm -rf %{buildroot}%{_libdir}/tcl/tcl8.?/sqlite3*
+find %{buildroot} -type f -name "*.la" -delete -print
+
+%post -n libsqlite3-0 -p /sbin/ldconfig
+%postun -n libsqlite3-0 -p /sbin/ldconfig
+
+%files
+%{_bindir}/sqlite3
+%{_mandir}/man1/sqlite3.1%{?ext_man}
+
+%files -n libsqlite3-0
+%{_libdir}/libsqlite3.so.*
+
+%files devel
+%{_includedir}/sqlite3.h
+%{_includedir}/sqlite3ext.h
+%{_libdir}/libsqlite3.so
+%{_libdir}/pkgconfig/sqlite3.pc
+
+%files tcl
+%tcl_archdir/*
+%doc %_mandir/mann/*
+
+%files doc
+%doc sqlite-doc-%{docversion}/*
+
+%changelog