automatic import of sqlite

4 files changed, 297 insertions, 0 deletions

diff --git a/.gitignore b/.gitignore
index e69de29..6d0db5a 100644
--- a/.gitignore
+++ b/.gitignore
@@ -0,0 +1,3 @@
+/sqlite-autoconf-3470000.tar.gz
+/sqlite-doc-3470000.zip
+/sqlite-src-3470000.zip
diff --git a/sources b/sources
new file mode 100644
index 0000000..caaf9dc
--- /dev/null
+++ b/sources
@@ -0,0 +1,3 @@
+dbbfbc9bd226c7b16721aba968a9a6c6  sqlite-autoconf-3470000.tar.gz
+c83a7c4c8551707cea8ebaac2306a6e8  sqlite-doc-3470000.zip
+eb324c9cffad85a85e6b11b5583d4ea6  sqlite-src-3470000.zip
diff --git a/sqlite-drop-tcl-at-sign.patch b/sqlite-drop-tcl-at-sign.patch
new file mode 100644
index 0000000..a1391bb
--- /dev/null
+++ b/sqlite-drop-tcl-at-sign.patch
@@ -0,0 +1,19 @@
+Index: sqlite/tool/buildtclext.tcl
+==================================================================
+--- a/tool/buildtclext.tcl
++++ a/tool/buildtclext.tcl
+@@ -140,12 +140,13 @@
+   if {[string length $OPTS]>1} {
+     append LDFLAGS $OPTS
+   }
+-  set CMD [subst $cmd]
+   if {$TCLMAJOR>8} {
+     set OUT libtcl9sqlite$VERSION.$SUFFIX
+   } else {
+     set OUT libsqlite$VERSION.$SUFFIX
+   }
++  set @ $OUT; # workaround for https://sqlite.org/forum/forumpost/6b1af7eb10884373
++  set CMD [subst $cmd]
+ }
+   
+ # Show information about prior installs
diff --git a/sqlite.spec b/sqlite.spec
new file mode 100644
index 0000000..f49079a
--- /dev/null
+++ b/sqlite.spec
@@ -0,0 +1,272 @@
+%bcond_without check
+
+Name:    sqlite
+Version: 3.47.0
+%global extver %(echo %{version} |awk -F. '{printf "%d%02d%02d00", $1,$2,$3}')
+Release: 1
+Summary: Embeded SQL database
+License: Public Domain
+URL:     http://www.sqlite.org/
+
+Source0: https://www.sqlite.org/2024/sqlite-src-%{extver}.zip
+Source1: http://www.sqlite.org/2024/sqlite-doc-%{extver}.zip
+Source2: https://www.sqlite.org/2024/sqlite-autoconf-%{extver}.tar.gz
+Patch0:  sqlite-drop-tcl-at-sign.patch
+
+BuildRequires: gcc autoconf tcl tcl-devel
+BuildRequires: ncurses-devel readline-devel glibc-devel
+BuildRequires: rpm_macro(tcl_sitearch)
+
+Provides:  %{name}-libs = %{version}-%{release}
+Obsoletes: %{name}-libs < %{version}-%{release}
+Provides:  lemon = %{version}-%{release}
+Obsoletes: lemon < %{version}-%{release}
+Provides:  %{name}-analyzer = %{version}-%{release}
+Obsoletes: %{name}-analyzer < %{version}-%{release}
+Provides:  %{name}-tcl = %{version}-%{release}
+Obsoletes: %{name}-tcl < %{version}-%{release}
+
+%description
+SQLite is a C-language library that implements a small, fast, self-contained,
+high-reliability, full-featured, SQL database engine. SQLite is the most used
+database engine in the world. SQLite is built into all mobile phones and most
+computers and comes bundled inside countless other applications that people
+use every day.It also include lemon and sqlite3_analyzer and tcl tools.
+
+%package devel
+Summary:  Including header files and library for the developing of sqlite
+Requires: %{name}%{?_isa} = %{version}-%{release}
+
+%description devel
+This contains dynamic libraries and header files for the developing of sqlite.
+
+%package help
+Summary:   Man file and documentation for sqlite
+BuildArch: noarch
+Provides:  %{name}-doc = %{version}-%{release}
+Obsoletes: %{name}-doc < %{version}-%{release}
+
+%description help
+This contains man files and HTML files for the using of sqlite.
+
+
+%prep
+#autosetup will fail because of 2 zip files
+%setup -q -a1 -n %{name}-src-%{extver}
+%autopatch -p1
+
+rm -f %{name}-doc-%{extver}/sqlite.css~ || :
+
+%build
+
+autoconf
+export CFLAGS="$RPM_OPT_FLAGS $RPM_LD_FLAGS -DSQLITE_ENABLE_COLUMN_METADATA=1 \
+               -DSQLITE_DISABLE_DIRSYNC=1 -DSQLITE_ENABLE_FTS3=3 \
+               -DSQLITE_ENABLE_RTREE=1 -DSQLITE_SECURE_DELETE=1 \
+               -DSQLITE_ENABLE_UNLOCK_NOTIFY=1 -DSQLITE_ENABLE_DBSTAT_VTAB=1 \
+               -DSQLITE_ENABLE_FTS3_PARENTHESIS=1 -DSQLITE_ENABLE_JSON1=1 \
+               -Wall -fno-strict-aliasing"
+
+%configure --enable-fts5 \
+           --enable-threadsafe \
+           --enable-load-extension \
+	   --disable-static \
+           TCLLIBDIR=%{tcl_sitearch}/sqlite3
+
+# rpath removal
+sed -i 's|^hardcode_libdir_flag_spec=.*|hardcode_libdir_flag_spec=""|g' libtool
+sed -i 's|^runpath_var=LD_RUN_PATH|runpath_var=DIE_RPATH_DIE|g' libtool
+
+%make_build
+
+%make_build sqlite3_analyzer
+
+%install
+%make_install
+%delete_la
+
+install -D -m 755 lemon %{buildroot}%{_bindir}/lemon
+install -D -m 644 tool/lempar.c %{buildroot}%{_datadir}/lemon/lempar.c
+install -D -m 644 sqlite3.1 %{buildroot}%{_mandir}/man1/sqlite3.1
+install -D -m 755 sqlite3_analyzer %{buildroot}%{_bindir}/sqlite3_analyzer
+chmod 755 %{buildroot}/%{tcl_sitearch}/sqlite3/*.so
+
+
+%if %{with check}
+%check
+export LD_LIBRARY_PATH=`pwd`/.libs
+export MALLOC_CHECK_=3
+
+%ifarch x86_64 %{ix86}
+%else
+rm test/csv01.test
+%endif
+%ifarch loongarch64
+rm -rf test/thread1.test
+rm -rf test/thread2.test
+%endif
+
+%make_build test
+%endif # with check
+
+%files
+%doc README.md
+%{_bindir}/{sqlite3,lemon,sqlite3_analyzer}
+%{_libdir}/*.so.*
+%{_datadir}/lemon
+%{tcl_sitearch}/sqlite3
+
+%files devel
+%{_includedir}/*.h
+%{_libdir}/*.so
+%{_libdir}/pkgconfig/*.pc
+
+%files help
+%doc %{name}-doc-%{extver}/*
+%{_mandir}/man*/*
+
+%changelog
+* Tue Oct 22 2024 Funda Wang <fundawang@yeah.net> - 3.47.0-1
+- update to 3.47.0
+
+* Tue Aug 13 2024 Funda Wang <fundawang@yeah.net> - 3.46.1-1
+- update to 3.46.1
+
+* Tue Feb 27 2024 Zheng Zhenyu <zheng.zhenyu@outlook.com> - 3.42.0-1
+- Bump version to fix CVE-2024-0232
+
+* Wed Jan 3 2024 mazhao <mazhao12@huawei.com> - 3.37.2-7
+- fix the CVE-2023-7104
+
+* Mon Aug 7 2023 zhuwentao <zhuwentao5@huawei.com> - 3.37.2-6
+- fix the CVE-2023-36191
+
+* Fri Jan 13 2023 Wenlong Zhang<zhangwenlong@loongson.cn> - 3.37.2-5
+- remove fail testcase for loongarch
+
+* Wed Dec 14 2022 zhuwentao <zhuwentao5@huawei.com> - 3.37.2-4
+- fix the CVE-2022-46908
+
+* Wed Sep 14 2022 zhuwentao <zhuwentao5@huawei.com> - 3.37.2-3
+- fix build problem
+
+* Mon Sep 5 2022 zhuwentao <zhuwentao5@huawei.com> - 3.37.2-2
+- fix integer overflow on gigabyte string
+
+* Mon Aug 29 2022 zhuwentao <zhuwentao5@huawei.com> - 3.37.2-1
+- update to 3.37.2
+
+* Tue Aug 16 2022 liusirui <liusirui@huawei.com> - 3.36.0-3
+- fix the CVE-2022-35737.
+
+* Sat Nov 27 2021 wbq_sky <wangbingquan@huawei.com> - 3.36.0-2
+- fix the CVE-2021-36690.
+
+* Fri Nov 25 2021 wbq_sky <wangbingquan@huawei.com> - 3.36.0-1
+- update to 3.36.0.
+
+* Fri Sep 26 2021 wbq_sky <wangbingquan@huawei.com> - 3.34.0-4
+- fix the uninitialized value used in pattern match.
+
+* Fri Sep 3 2021 wbq_sky <wangbingquan@huawei.com> - 3.34.0-3
+- fix the null reference in the tigger statement.
+
+* Fri Sep 3 2021 wbq_sky <wangbingquan@huawei.com> - 3.34.0-2
+- fix the infinite loop problem in the trim function while the pattern is well formed.
+
+* Thu Jan 14 2021 yanglongkang <yanglongkang@huawei.com> - 3.34.0-1
+- update package to 3.34.0
+
+* Thu Sep 3 2020 lihaotian<lihaotian9@huawei.com> - 3.32.3-3
+- update source0 url
+
+* Tue Jul 21 2020 jixinjie <jixinjie@huawei.com> - 3.32.3-2
+- update yaml file
+
+* Tue Jul 21 2020 jixinjie <jixinjie@huawei.com> - 3.32.3-1
+- update package to 3.32.3
+
+* Tue Jun 30 2020 volcanodragon <linfeilong@huawei.com> - 3.24.0-12
+- Type:enhancement
+- ID:NA
+- SUG:NA
+- DESC:rename patches
+
+* Tue Jun 23 2020 yanglongkang <yanglongkang@huawei.com> - 3.24.0-11
+- Type:cves
+- ID:CVE-2020-13434 CVE-2020-13435 CVE-2020-13630 CVE-2020-13632
+- SUG:NA
+- DESC:fix CVE-2020-13434 CVE-2020-13435 CVE-2020-13630 CVE-2020-13632
+
+* Sun Apr 19 2020 ethan848 <mingfangsen@huawei.com>
+- Type:enhancement
+- ID:NA
+- SUG:NA
+- DESC:CVE-2020-11655 fixed
+
+* Tue Mar 10 2020 steven <steven_ygui@163.com> - 3.24.0-9
+- Type:enhancement
+- ID:NA
+- SUG:NA
+- DESC:CVE-2018-20505, CVE-2020-9327 fixed
+
+* Wed Jan 11 2020 openEuler Buildteam <buildteam@openeuler.org> - 3.24.0-8
+- Type:enhancement
+- ID:NA
+- SUG:NA
+- DESC:CVE-2019-19959 fixed
+
+* Wed Jan 11 2020 openEuler Buildteam <buildteam@openeuler.org> - 3.24.0-7
+- Type:enhancement
+- ID:NA
+- SUG:NA
+- DESC:Fix CVE-2019-19923 CVE-2019-19924 CVE-2019-19925 CVE-2019-19926 CVE-2019-20218
+
+* Fri Jan 3 2020 openEuler Buildteam <buildteam@openeuler.org> - 3.24.0-6
+- Type:cves
+- ID:CVE-2019-9936,CVE-2019-9937
+- SUG:NA
+- DESC:fix cve
+
+* Sat Dec 21 2019 openEuler Buildteam <buildteam@openeuler.org> - 3.24.0-5
+- Type:bugfix
+- ID:NA
+- SUG:NA
+- DESC:fix CVE bug
+
+* Wed Sep 11 2019 openEuler Buildteam <buildteam@openeuler.org> - 3.24.0-4
+- Type:enhancemnet
+- ID:NA
+- SUG:NA
+- DESC:remove debuginfo
+
+* Wed Aug 28 2019 openEuler Buildteam <buildteam@openeuler.org> - 3.24.0-3
+- Type:enhancemnet
+- ID:NA
+- SUG:restart
+- DESC:openEuler Debranding
+
+* Tue Aug 20 2019 wubo<wubo40@huawei.com> - 3.24.0-2.h4
+- Type:
+- ID:
+- SUG:NA
+- DESC:rename patch
+
+* Thu Aug 15 2019 wubo<wubo40@huawei.com> - 3.24.0-2.h3
+- Type:bugfix
+- ID:CVE-2019-8457
+- SUG:NA
+- DESC:heap out-of-bound read in function rtreenode()
+
+* Sat Mar 23 2019 Xiaoqi Guo<guoxiaoqi2@huawei.com> - 3.24.0-2.h2
+- Type:bugfix
+- ID:NA
+- SUG:NA
+- DESC:backport patch from community
+
+* Sat Mar 23 2019 luochunsheng<luochunsheng@huawei.com> - 3.24.0-2.h1
+- Type:cves
+- ID:CVE-2018-20346
+- SUG:NA
+- DESC:CVE-2018-20346
+- Package init