Use POSIX collation in the Postgres registry #417
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
| # This workflow tests Sqitch's Vertica engine on all supported versions of | |
| # Vertica. It runs for pushes and pull requests on the `main`, `develop`, | |
| # `**vertica**`, and `**engine**` branches. | |
| name: 🔺 Vertica | |
| on: | |
| push: | |
| branches: [main, develop, "**engine**", "**vertica**" ] | |
| pull_request: | |
| branches: [main, develop, "**engine**", "**vertica**" ] | |
| jobs: | |
| Vertica: | |
| strategy: | |
| matrix: | |
| include: | |
| - { label: '12.0', version: 12.0.4-0, image: vertica/vertica-ce, db: VMart } | |
| - { label: '11.0', version: 11.1.1-0, image: vertica/vertica-ce, db: VMart } | |
| - { label: '10.1', version: 10.1.1-0, image: vertica/vertica-ce, db: VMart } | |
| - { label: '9.2', version: 9.2.1-0, image: cjonesy/docker-vertica, db: docker } | |
| - { label: '9.1', version: 9.1.1-0, image: cjonesy/docker-vertica, db: docker } | |
| - { label: '8.1', version: 8.1.1-0, image: cjonesy/docker-vertica, db: docker } | |
| - { label: '8.0', version: 8.0.0-0, image: cjonesy/docker-vertica, db: docker } | |
| - { label: '7.2', version: 7.2.3-18, image: cjonesy/docker-vertica, db: docker } | |
| name: 🔺 Vertica ${{ matrix.label }} | |
| runs-on: ubuntu-latest | |
| services: | |
| vertica: | |
| image: ${{ matrix.image }}:${{ matrix.version }} | |
| ports: [ 5433 ] | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - name: Setup Clients | |
| run: .github/ubuntu/vertica.sh | |
| - name: Setup Perl | |
| id: perl | |
| uses: shogo82148/actions-setup-perl@v1 | |
| with: { perl-version: latest } | |
| - name: Cache CPAN Modules | |
| uses: actions/cache@v4 | |
| with: | |
| path: local | |
| key: perl-${{ steps.perl.outputs.perl-hash }} | |
| - run: cpm install --verbose --show-build-log-on-failure --no-test --with-recommends --cpanfile dist/cpanfile | |
| - run: cpm install --verbose --show-build-log-on-failure --no-test --with-recommends DBD::ODBC | |
| - name: prove | |
| env: | |
| PERL5LIB: "${{ github.workspace }}/local/lib/perl5" | |
| LIVE_VERTICA_REQUIRED: true | |
| SQITCH_TEST_VSQL_URI: db:vertica://dbadmin@localhost:${{ job.services.vertica.ports[5433] }}/${{ matrix.db }}?Driver=Vertica | |
| run: prove -lvr t/vertica.t |