Fix behavioural differences due to return type and handle constant string literal inputs differently for COALESCE function #11437
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: Major Version Upgrade Tests for singledb mode | |
| on: [push, pull_request] | |
| jobs: | |
| run-babelfish-mvu-tests-singledb: | |
| env: | |
| env: | |
| OLD_INSTALL_DIR: postgres13 | |
| NEW_INSTALL_DIR: postgres14 | |
| ENGINE_BRANCH_FROM: BABEL_1_2_STABLE__PG_13_6 | |
| EXTENSION_BRANCH_FROM: BABEL_1_2_STABLE | |
| runs-on: ubuntu-20.04 | |
| steps: | |
| - uses: actions/checkout@v2 | |
| - name: Setup Base version ${{ env.ENGINE_BRANCH_FROM }} and run prepare tests | |
| id: setup-base-version | |
| if: always() | |
| uses: ./.github/composite-actions/setup-base-version | |
| with: | |
| engine_branch: ${{ env.ENGINE_BRANCH_FROM }} | |
| extension_branch: ${{ env.EXTENSION_BRANCH_FROM }} | |
| install_dir: ${{ env.OLD_INSTALL_DIR }} | |
| migration_mode: 'single-db' | |
| - name: Upgrade to latest version and run verify-cleanup tests | |
| id: upgrade-and-verify | |
| if: always() && steps.setup-base-version.outcome == 'success' | |
| uses: ./.github/composite-actions/major-version-upgrade-util | |
| with: | |
| engine_branch: latest | |
| extension_branch: latest | |
| is_final_ver: true | |
| pg_old_dir: ${{ env.OLD_INSTALL_DIR }} | |
| pg_new_dir: ${{ env.NEW_INSTALL_DIR }} | |
| migration_mode: "single-db" | |
| - name: Upload New Postgres log | |
| if: always() && steps.upgrade-and-verify.outcome == 'failure' | |
| uses: actions/upload-artifact@v2 | |
| with: | |
| name: postgres-log-new | |
| path: ~/${{env.NEW_INSTALL_DIR}}/data/logfile | |
| - name: Upload upgrade Log | |
| if: always() && steps.upgrade-and-verify.outcome == 'failure' | |
| uses: actions/upload-artifact@v2 | |
| with: | |
| name: upgrade-logs | |
| path: ~/upgrade/*.log | |
| - name: Rename Test Summary Files | |
| id: test-file-rename | |
| if: always() && ( steps.upgrade-and-verify.outcome == 'failure' || steps.setup-base-version.outcome == 'failure' ) | |
| run: | | |
| cd test/JDBC/Info | |
| timestamp=`ls -Art | tail -n 1` | |
| cd $timestamp | |
| cp $timestamp.diff ~/upgrade/output-diff.diff | |
| cp "$timestamp"_runSummary.log ~/upgrade/run-summary.log | |
| mkdir -p ~/failed-testscript-outputs | |
| for f in $(grep "[A-Za-z_\-]*:[ ]*Failed" $timestamp"_runSummary.log" | cut -d ":" -f 1); | |
| do | |
| if [[ -f ../../output/$f".out" ]]; then | |
| cp ../../output/$f".out" ~/failed-testscript-outputs/$f".out" | |
| elif [[ -f ../../output/"singledb__preparation__"$f".out" ]]; then | |
| cp ../../output/"singledb__preparation__"$f".out" ~/failed-testscript-outputs/"singledb__preparation__"$f".out" | |
| else | |
| cp ../../output/"singledb__verification_cleanup__"$f".out" ~/failed-testscript-outputs/"singledb__verification_cleanup__"$f".out" | |
| fi | |
| done | |
| - name: Upload Run Summary | |
| if: always() && steps.test-file-rename.outcome == 'success' | |
| uses: actions/upload-artifact@v2 | |
| with: | |
| name: Test Run Artificats | |
| path: | | |
| ~/upgrade/*.log | |
| ~/upgrade/*.diff | |
| ~/failed-testscript-outputs |