From fe54ced5ac54756f5c6f0bb92ad5918907f8e2a3 Mon Sep 17 00:00:00 2001 From: CoprDistGit Date: Sat, 16 Nov 2024 13:12:57 +0000 Subject: automatic import of sqlite --- .gitignore | 3 + sources | 3 + sqlite-drop-tcl-at-sign.patch | 19 +++ sqlite.spec | 272 ++++++++++++++++++++++++++++++++++++++++++ 4 files changed, 297 insertions(+) create mode 100644 sources create mode 100644 sqlite-drop-tcl-at-sign.patch create mode 100644 sqlite.spec 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 - 3.47.0-1 +- update to 3.47.0 + +* Tue Aug 13 2024 Funda Wang - 3.46.1-1 +- update to 3.46.1 + +* Tue Feb 27 2024 Zheng Zhenyu - 3.42.0-1 +- Bump version to fix CVE-2024-0232 + +* Wed Jan 3 2024 mazhao - 3.37.2-7 +- fix the CVE-2023-7104 + +* Mon Aug 7 2023 zhuwentao - 3.37.2-6 +- fix the CVE-2023-36191 + +* Fri Jan 13 2023 Wenlong Zhang - 3.37.2-5 +- remove fail testcase for loongarch + +* Wed Dec 14 2022 zhuwentao - 3.37.2-4 +- fix the CVE-2022-46908 + +* Wed Sep 14 2022 zhuwentao - 3.37.2-3 +- fix build problem + +* Mon Sep 5 2022 zhuwentao - 3.37.2-2 +- fix integer overflow on gigabyte string + +* Mon Aug 29 2022 zhuwentao - 3.37.2-1 +- update to 3.37.2 + +* Tue Aug 16 2022 liusirui - 3.36.0-3 +- fix the CVE-2022-35737. + +* Sat Nov 27 2021 wbq_sky - 3.36.0-2 +- fix the CVE-2021-36690. + +* Fri Nov 25 2021 wbq_sky - 3.36.0-1 +- update to 3.36.0. + +* Fri Sep 26 2021 wbq_sky - 3.34.0-4 +- fix the uninitialized value used in pattern match. + +* Fri Sep 3 2021 wbq_sky - 3.34.0-3 +- fix the null reference in the tigger statement. + +* Fri Sep 3 2021 wbq_sky - 3.34.0-2 +- fix the infinite loop problem in the trim function while the pattern is well formed. + +* Thu Jan 14 2021 yanglongkang - 3.34.0-1 +- update package to 3.34.0 + +* Thu Sep 3 2020 lihaotian - 3.32.3-3 +- update source0 url + +* Tue Jul 21 2020 jixinjie - 3.32.3-2 +- update yaml file + +* Tue Jul 21 2020 jixinjie - 3.32.3-1 +- update package to 3.32.3 + +* Tue Jun 30 2020 volcanodragon - 3.24.0-12 +- Type:enhancement +- ID:NA +- SUG:NA +- DESC:rename patches + +* Tue Jun 23 2020 yanglongkang - 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 +- Type:enhancement +- ID:NA +- SUG:NA +- DESC:CVE-2020-11655 fixed + +* Tue Mar 10 2020 steven - 3.24.0-9 +- Type:enhancement +- ID:NA +- SUG:NA +- DESC:CVE-2018-20505, CVE-2020-9327 fixed + +* Wed Jan 11 2020 openEuler Buildteam - 3.24.0-8 +- Type:enhancement +- ID:NA +- SUG:NA +- DESC:CVE-2019-19959 fixed + +* Wed Jan 11 2020 openEuler Buildteam - 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 - 3.24.0-6 +- Type:cves +- ID:CVE-2019-9936,CVE-2019-9937 +- SUG:NA +- DESC:fix cve + +* Sat Dec 21 2019 openEuler Buildteam - 3.24.0-5 +- Type:bugfix +- ID:NA +- SUG:NA +- DESC:fix CVE bug + +* Wed Sep 11 2019 openEuler Buildteam - 3.24.0-4 +- Type:enhancemnet +- ID:NA +- SUG:NA +- DESC:remove debuginfo + +* Wed Aug 28 2019 openEuler Buildteam - 3.24.0-3 +- Type:enhancemnet +- ID:NA +- SUG:restart +- DESC:openEuler Debranding + +* Tue Aug 20 2019 wubo - 3.24.0-2.h4 +- Type: +- ID: +- SUG:NA +- DESC:rename patch + +* Thu Aug 15 2019 wubo - 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 - 3.24.0-2.h2 +- Type:bugfix +- ID:NA +- SUG:NA +- DESC:backport patch from community + +* Sat Mar 23 2019 luochunsheng - 3.24.0-2.h1 +- Type:cves +- ID:CVE-2018-20346 +- SUG:NA +- DESC:CVE-2018-20346 +- Package init -- cgit v1.2.3