db_datawriter should have update privilege on sequences #12646
Workflow file for this run
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| name: TAP Tests | |
| on: [push, pull_request] | |
| jobs: | |
| run-babelfish-tap-tests: | |
| env: | |
| OLD_INSTALL_DIR: psql_source | |
| NEW_INSTALL_DIR: psql_target | |
| ENGINE_BRANCH_OLD: BABEL_2_6_STABLE__PG_14_9 | |
| EXTENSION_BRANCH_OLD: BABEL_2_6_STABLE | |
| INSTALL_DIR_16: psql16 | |
| ENGINE_BRANCH_16: BABEL_4_X_DEV__PG_16_X | |
| runs-on: ubuntu-20.04 | |
| steps: | |
| - uses: actions/checkout@v2 | |
| id: checkout | |
| - name: Install Dependencies | |
| id: install-dependencies | |
| if: always() | |
| uses: ./.github/composite-actions/install-dependencies | |
| - name: Install Tap Tests Dependencies | |
| id: install-tap-dependencies | |
| if: always() && steps.install-dependencies.outcome == 'success' | |
| run: | | |
| export PERL_MM_USE_DEFAULT=1 | |
| sudo perl -MCPAN -e 'install IPC::Run' | |
| shell: bash | |
| - name: Install Kerberos Dependencies | |
| id: install-kerberos-dependencies | |
| if: always() && steps.install-tap-dependencies.outcome == 'success' | |
| run: | | |
| cd ~ | |
| export DEBIAN_FRONTEND=noninteractive | |
| sudo -E apt-get install krb5-admin-server krb5-kdc krb5-user libkrb5-dev -y -qq | |
| shell: bash | |
| - name: Build Modified Postgres using ${{env.ENGINE_BRANCH_16}} | |
| id: build-modified-postgres-16 | |
| if: always() && steps.install-kerberos-dependencies.outcome == 'success' | |
| uses: ./.github/composite-actions/build-modified-postgres | |
| with: | |
| engine_branch: ${{env.ENGINE_BRANCH_16}} | |
| install_dir: ${{env.INSTALL_DIR_16}} | |
| - name: Build Modified Postgres using ${{env.ENGINE_BRANCH_OLD}} | |
| id: build-modified-postgres-old | |
| if: always() && steps.build-modified-postgres-16.outcome == 'success' | |
| uses: ./.github/composite-actions/build-modified-postgres | |
| with: | |
| engine_branch: ${{env.ENGINE_BRANCH_OLD}} | |
| install_dir: ${{env.OLD_INSTALL_DIR}} | |
| - name: Compile ANTLR | |
| id: compile-antlr | |
| if: always() && steps.build-modified-postgres-old.outcome == 'success' | |
| uses: ./.github/composite-actions/compile-antlr | |
| with: | |
| version: 4.9.3 | |
| install_dir: ${{env.OLD_INSTALL_DIR}} | |
| - name: Build PostGIS Extension using ${{env.EXTENSION_BRANCH_OLD}} | |
| id: build-postgis-extension-old | |
| if: always() && steps.compile-antlr.outcome == 'success' | |
| run: | | |
| cd .. | |
| export CC='ccache gcc' | |
| export CMAKE_C_COMPILER_LAUNCHER=ccache | |
| export CMAKE_CXX_COMPILER_LAUNCHER=ccache | |
| sudo apt-get install wget | |
| max_retries=20 | |
| retries=0 | |
| until [ $retries -ge $max_retries ] | |
| do | |
| wget http://postgis.net/stuff/postgis-3.5.0.tar.gz && break | |
| retries=$((retries+1)) | |
| done | |
| tar -xvzf postgis-3.5.0.tar.gz | |
| retries1=0 | |
| until [ $retries1 -ge $max_retries ] | |
| do | |
| wget https://download.osgeo.org/proj/proj-9.2.1.tar.gz && break | |
| retries1=$((retries1+1)) | |
| done | |
| tar -xvzf proj-9.2.1.tar.gz | |
| cd proj-9.2.1 | |
| if [ ! -d "build" ]; then | |
| mkdir build | |
| fi | |
| cd build | |
| cmake -DCMAKE_INSTALL_LIBDIR="lib/x86_64-linux-gnu" -DCMAKE_INSTALL_PREFIX="/usr" .. | |
| cmake --build . | |
| sudo cmake --build . --target install | |
| cd ../../postgis-3.5.0 | |
| ./configure --without-protobuf --without-raster --with-pgconfig=$HOME/psql_source/bin/pg_config | |
| make USE_PGXS=1 PG_CONFIG=~/psql_source/bin/pg_config | |
| sudo make USE_PGXS=1 PG_CONFIG=~/psql_source/bin/pg_config install | |
| shell: bash | |
| - name: Build Extensions using ${{env.EXTENSION_BRANCH_OLD}} | |
| id: build-extensions-old | |
| if: always() && steps.build-postgis-extension-old.outcome == 'success' | |
| uses: ./.github/composite-actions/build-extensions | |
| with: | |
| install_dir: ${{env.OLD_INSTALL_DIR}} | |
| extension_branch: ${{env.EXTENSION_BRANCH_OLD}} | |
| - uses: actions/checkout@v2 | |
| - name: Build Modified Postgres using latest version | |
| id: build-modified-postgres-new | |
| if: always() && steps.build-extensions-old.outcome == 'success' | |
| uses: ./.github/composite-actions/build-modified-postgres | |
| with: | |
| tap_tests: 'yes' | |
| install_dir: ${{env.NEW_INSTALL_DIR}} | |
| - name: Compile new ANTLR | |
| id: compile-new-antlr | |
| if: always() && steps.build-modified-postgres-new.outcome == 'success' | |
| uses: ./.github/composite-actions/compile-antlr | |
| with: | |
| install_dir: ${{env.NEW_INSTALL_DIR}} | |
| - name: Build Extensions using latest version | |
| id: build-extensions-new | |
| if: always() && steps.compile-new-antlr.outcome == 'success' | |
| uses: ./.github/composite-actions/build-extensions | |
| with: | |
| install_dir: ${{env.NEW_INSTALL_DIR}} | |
| - name: Build PostGIS Extension | |
| id: build-postgis-extension | |
| if: always() && steps.build-extensions-new.outcome == 'success' | |
| uses: ./.github/composite-actions/build-postgis-extension | |
| with: | |
| install_dir: ${{env.NEW_INSTALL_DIR}} | |
| - name: Run TAP Tests | |
| id: tap | |
| if: always() && steps.build-postgis-extension.outcome == 'success' | |
| timeout-minutes: 5 | |
| run: | | |
| export PG_CONFIG=~/${{env.NEW_INSTALL_DIR}}/bin/pg_config | |
| export PATH=/opt/mssql-tools/bin:$PATH | |
| export oldinstall=$HOME/${{env.OLD_INSTALL_DIR}} | |
| export installdir16=$HOME/${{env.INSTALL_DIR_16}} | |
| cd contrib/babelfishpg_tds | |
| make installcheck PROVE_TESTS="t/001_tdspasswd.pl t/002_tdskerberos.pl t/003_bbfextnotloaded.pl t/004_bbfdumprestore.pl" | |
| - name: Upload Logs | |
| if: always() && steps.tap.outcome == 'failure' | |
| uses: actions/upload-artifact@v4 | |
| with: | |
| name: tap_tests_logs | |
| path: contrib/babelfishpg_tds/test/tmp_check |