Script 'mail_helper' called by obssrc Hello community, here is the log from the commit of package postgresql-libversion for openSUSE:Factory checked in at 2024-05-01 14:56:56 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Comparing /work/SRC/openSUSE:Factory/postgresql-libversion (Old) and /work/SRC/openSUSE:Factory/.postgresql-libversion.new.1880 (New) ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Package is "postgresql-libversion" Wed May 1 14:56:56 2024 rev:3 rq:1171022 version:2.0.1 Changes: -------- --- /work/SRC/openSUSE:Factory/postgresql-libversion/postgresql-libversion.changes 2023-11-30 22:01:42.301908058 +0100 +++ /work/SRC/openSUSE:Factory/.postgresql-libversion.new.1880/postgresql-libversion.changes 2024-05-01 14:57:15.479662417 +0200 @@ -1,0 +2,6 @@ +Tue Apr 30 17:14:44 UTC 2024 - Andreas Stieger <andreas.stie...@gmx.de> + +- update to 2.0.1: + * remove unused function wrap_version_compare_simple + +------------------------------------------------------------------- Old: ---- postgresql-libversion-2.0.0.tar.gz New: ---- postgresql-libversion-2.0.1.tar.gz ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Other differences: ------------------ ++++++ postgresql-libversion.spec ++++++ --- /var/tmp/diff_new_pack.0EVCX8/_old 2024-05-01 14:57:15.923678527 +0200 +++ /var/tmp/diff_new_pack.0EVCX8/_new 2024-05-01 14:57:15.923678527 +0200 @@ -1,7 +1,7 @@ # # spec file for package postgresql-libversion # -# Copyright (c) 2023 Andreas Stieger <andreas.stie...@gmx.de> +# Copyright (c) 2024 Andreas Stieger <andreas.stie...@gmx.de> # # All modifications and additions to the file contributed by third parties # remain the property of their copyright owners, unless otherwise agreed @@ -20,7 +20,7 @@ %define ext_name libversion %define __provides_exclude ^lib.*\\.so.*$ Name: %{pg_name}-%{ext_name} -Version: 2.0.0 +Version: 2.0.1 Release: 0 Summary: PostgreSQL extension for version string comparison License: MIT @@ -46,6 +46,10 @@ %install %make_install +%check +# https://github.com/repology/postgresql-libversion/blob/master/.github/workflows/ci.yml +# incolves running a server, not implementing that for testing + %files %license COPYING %{pg_config_pkglibdir}/%{ext_name}.so ++++++ postgresql-libversion-2.0.0.tar.gz -> postgresql-libversion-2.0.1.tar.gz ++++++ diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/postgresql-libversion-2.0.0/.github/workflows/ci.yml new/postgresql-libversion-2.0.1/.github/workflows/ci.yml --- old/postgresql-libversion-2.0.0/.github/workflows/ci.yml 1970-01-01 01:00:00.000000000 +0100 +++ new/postgresql-libversion-2.0.1/.github/workflows/ci.yml 2024-04-08 17:48:27.000000000 +0200 @@ -0,0 +1,55 @@ +name: CI +on: [ push, pull_request ] +jobs: + build: + runs-on: ubuntu-latest + strategy: + matrix: + include: + - { libversion: master, postgresql: 16, cc: gcc } + # libversion versions + - { libversion: 3.0.2, postgresql: 16, cc: gcc } + - { libversion: 3.0.1, postgresql: 16, cc: gcc } + - { libversion: 3.0.0, postgresql: 16, cc: gcc } + # compilers + - { libversion: master, postgresql: 16, cc: clang } + # postgresql versions + - { libversion: master, postgresql: 10, cc: gcc } + - { libversion: master, postgresql: 11, cc: gcc } + - { libversion: master, postgresql: 12, cc: gcc } + - { libversion: master, postgresql: 13, cc: gcc } + - { libversion: master, postgresql: 14, cc: gcc } + - { libversion: master, postgresql: 15, cc: gcc } + - { libversion: master, postgresql: 16, cc: gcc } + fail-fast: false + steps: + - uses: actions/checkout@v4 + - name: Setup postgresql repository + run: | + sudo install -d /usr/share/postgresql-common/pgdg + sudo curl -o /usr/share/postgresql-common/pgdg/apt.postgresql.org.asc --fail https://www.postgresql.org/media/keys/ACCC4CF8.asc + sudo sh -c 'echo "deb [signed-by=/usr/share/postgresql-common/pgdg/apt.postgresql.org.asc] https://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list' + - name: Install postgresql + run: | + sudo apt-get update + sudo apt-get purge 'postgresql*' >/dev/null 2>&1 || true + sudo apt-get install postgresql-${{ matrix.postgresql }} postgresql-client-${{ matrix.postgresql }} postgresql-server-dev-${{ matrix.postgresql }} + sudo pg_ctlcluster ${{ matrix.postgresql }} main restart + sudo -u postgres createuser -s "$USER" || true + - name: Install libversion dependency + run: | + mkdir _libversion + cd _libversion + wget -qO- https://github.com/repology/libversion/archive/${{ matrix.libversion }}.tar.gz | tar -xzf- --strip-components 1 + cmake . + make + sudo make install + sudo ldconfig + - name: Build + run: make CC=${{ matrix.cc }} + - name: Install + run: sudo make install + - name: Installcheck + run: | + make installcheck + if test -e regression.diffs; then cat regression.diffs; false; fi diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/postgresql-libversion-2.0.0/.gitignore new/postgresql-libversion-2.0.1/.gitignore --- old/postgresql-libversion-2.0.0/.gitignore 2019-09-11 21:19:26.000000000 +0200 +++ new/postgresql-libversion-2.0.1/.gitignore 2024-04-08 17:48:27.000000000 +0200 @@ -1,3 +1,4 @@ +libversion.bc libversion.o libversion.so regression.diffs diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/postgresql-libversion-2.0.0/.travis.yml new/postgresql-libversion-2.0.1/.travis.yml --- old/postgresql-libversion-2.0.0/.travis.yml 2019-09-11 21:19:26.000000000 +0200 +++ new/postgresql-libversion-2.0.1/.travis.yml 1970-01-01 01:00:00.000000000 +0100 @@ -1,32 +0,0 @@ -language: c -dist: xenial -sudo: required -compiler: - - gcc - - clang -addons: - postgresql: "10" - apt: - packages: - - postgresql-server-dev-10 -env: - matrix: - - LIBVERSION=master -before_install: - - wget -qO- https://github.com/repology/libversion/archive/$LIBVERSION.tar.gz | tar -xzf- && ( cd libversion-$LIBVERSION && cmake . && make && sudo make install && sudo ldconfig ) -script: - - make - - sudo make install - - make installcheck - - if test -e regression.diffs; then cat regression.diffs; fi - - - sudo -u postgres psql -c "CREATE DATABASE ext_test1;" - - sudo -u postgres psql -d ext_test1 -c "CREATE EXTENSION libversion" - - sudo -u postgres psql -d ext_test1 -c "SELECT pg_catalog.pg_describe_object(classid, objid, 0) FROM pg_catalog.pg_depend WHERE refclassid = 'pg_catalog.pg_extension'::pg_catalog.regclass AND refobjid = (SELECT oid FROM pg_catalog.pg_extension WHERE extname='libversion') and deptype='e' order by 1" > extension_contents.a - - - sudo -u postgres psql -c "CREATE DATABASE ext_test2;" - - sudo -u postgres psql -d ext_test2 -c "CREATE EXTENSION libversion VERSION '1.0.0'" - - sudo -u postgres psql -d ext_test2 -c "ALTER EXTENSION libversion UPDATE" - - sudo -u postgres psql -d ext_test2 -c "SELECT pg_catalog.pg_describe_object(classid, objid, 0) FROM pg_catalog.pg_depend WHERE refclassid = 'pg_catalog.pg_extension'::pg_catalog.regclass AND refobjid = (SELECT oid FROM pg_catalog.pg_extension WHERE extname='libversion') and deptype='e' order by 1" > extension_contents.b - - - if cmp -s extension_contents.a extension_contents.b; then echo "Extension update check passed"; else echo "Extension update sanity check failed!"; diff -u extension_contents.a extension_contents.b; false; fi diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/postgresql-libversion-2.0.0/COPYING new/postgresql-libversion-2.0.1/COPYING --- old/postgresql-libversion-2.0.0/COPYING 2019-09-11 21:19:26.000000000 +0200 +++ new/postgresql-libversion-2.0.1/COPYING 2024-04-08 17:48:27.000000000 +0200 @@ -1,4 +1,4 @@ -Copyright (c) 2017-2018 Dmitry Marakasov <amd...@amdmi3.ru> +Copyright (c) 2017-2020,2024 Dmitry Marakasov <amd...@amdmi3.ru> Contains code from PostgreSQL 9.6 citext extension: diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/postgresql-libversion-2.0.0/README.md new/postgresql-libversion-2.0.1/README.md --- old/postgresql-libversion-2.0.0/README.md 2019-09-11 21:19:26.000000000 +0200 +++ new/postgresql-libversion-2.0.1/README.md 2024-04-08 17:48:27.000000000 +0200 @@ -1,6 +1,6 @@ # postgresql-libversion -[](https://travis-ci.org/repology/postgresql-libversion) + PostgreSQL extension with support for version string comparison through [libversion](https://github.com/repology/libversion). @@ -24,19 +24,24 @@ ## Synopsis -``` -postgres=# CREATE EXTENSION libversion; -CREATE EXTENSION -postgres=# SELECT version_compare2('1.10', '1.2'); -1 -postgres=# SELECT version_compare2('1.0', '1.0.0'); -0 -postgres=# SELECT version_compare4('1.0p1', '1.0', VERSIONFLAG_P_IS_PATCH(), 0); -1 -postgres=# SELECT '1.10'::versiontext > '1.2'::versiontext; -t -postgres=# SELECT '1.0'::versiontext = '1.0.0'::versiontext; -t +```sql +CREATE EXTENSION libversion; +# CREATE EXTENSION + +SELECT version_compare2('1.10', '1.2'); +# 1 + +SELECT version_compare2('1.0', '1.0.0'); +# 0 + +SELECT version_compare4('1.0p1', '1.0', VERSIONFLAG_P_IS_PATCH(), 0); +# 1 + +SELECT '1.10'::versiontext > '1.2'::versiontext; +# t + +SELECT '1.0'::versiontext = '1.0.0'::versiontext; +# t ``` ## Installation diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/postgresql-libversion-2.0.0/libversion.c new/postgresql-libversion-2.0.1/libversion.c --- old/postgresql-libversion-2.0.0/libversion.c 2019-09-11 21:19:26.000000000 +0200 +++ new/postgresql-libversion-2.0.1/libversion.c 2024-04-08 17:48:27.000000000 +0200 @@ -31,6 +31,9 @@ #include "access/hash.h" #include "utils/builtins.h" #include "utils/formatting.h" +#if PG_MAJORVERSION_NUM >= 16 +#include "varatt.h" +#endif #include <libversion/version.h> @@ -76,22 +79,6 @@ * Standalone functions */ -PG_FUNCTION_INFO_V1(wrap_version_compare_simple); - -Datum -wrap_version_compare_simple(PG_FUNCTION_ARGS) -{ - text *left = PG_GETARG_TEXT_PP(0); - text *right = PG_GETARG_TEXT_PP(1); - - int32 result = versiontextcmp2(left, right); - - PG_FREE_IF_COPY(left, 0); - PG_FREE_IF_COPY(right, 1); - - PG_RETURN_INT32(result); -} - PG_FUNCTION_INFO_V1(wrap_version_compare2); Datum @@ -126,6 +113,10 @@ PG_RETURN_INT32(result); } +/* + * Constant wrappers + */ + PG_FUNCTION_INFO_V1(wrap_VERSIONFLAG_P_IS_PATCH); Datum