Read a field of a ROW column by descending it #17483
Workflow file for this run
This file contains hidden or 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: SQL Java CI | |
| on: | |
| pull_request: | |
| push: | |
| branches-ignore: | |
| - 'backport/**' | |
| - 'dependabot/**' | |
| paths: | |
| - '**/*.java' | |
| - '**/*.g4' | |
| - '!sql-jdbc/**' | |
| - '**gradle*' | |
| - '**lombok*' | |
| - 'integ-test/**' | |
| - '**/*.jar' | |
| - '**/*.pom' | |
| - '.github/workflows/sql-test-and-build-workflow.yml' | |
| merge_group: | |
| jobs: | |
| Get-CI-Image-Tag: | |
| uses: opensearch-project/opensearch-build/.github/workflows/get-ci-image-tag.yml@761e093b8c1349cc07f21c1d681d3b30bf9e1999 # main | |
| with: | |
| product: opensearch | |
| build-linux: | |
| needs: Get-CI-Image-Tag | |
| strategy: | |
| fail-fast: false | |
| matrix: | |
| java: [21, 25] | |
| test-type: ['unit', 'integration', 'doc'] | |
| runs-on: ubuntu-latest | |
| container: | |
| image: ${{ needs.Get-CI-Image-Tag.outputs.ci-image-version-linux }} | |
| options: ${{ needs.Get-CI-Image-Tag.outputs.ci-image-start-options }} | |
| steps: | |
| - name: Run start commands | |
| run: ${{ needs.Get-CI-Image-Tag.outputs.ci-image-start-command }} | |
| - uses: actions/checkout@34e114876b0b11c390a56381ad16ebd13914f8d5 # v4 | |
| - name: Set up JDK ${{ matrix.java }} | |
| uses: actions/setup-java@c1e323688fd81a25caa38c78aa6df2d33d3e20d9 # v4 | |
| with: | |
| distribution: 'temurin' | |
| java-version: ${{ matrix.java }} | |
| - name: Build and Test | |
| run: | | |
| chown -R 1000:1000 `pwd` | |
| if [ "${{ matrix.test-type }}" = "unit" ]; then | |
| su `id -un 1000` -c "./gradlew --continue build -x integTest -x tracingIntegTest -x yamlRestTest -x doctest" | |
| elif [ "${{ matrix.test-type }}" = "integration" ]; then | |
| su `id -un 1000` -c "./gradlew --continue integTest tracingIntegTest yamlRestTest" | |
| else | |
| su `id -un 1000` -c "./gradlew --continue doctest" | |
| fi | |
| - name: Create Artifact Path | |
| if: ${{ matrix.test-type == 'unit' }} | |
| run: | | |
| mkdir -p opensearch-sql-builds | |
| cp -r ./plugin/build/distributions/*.zip opensearch-sql-builds/ | |
| - name: Upload SQL Coverage Report Artifact | |
| if: ${{ !cancelled() && matrix.test-type == 'unit' && matrix.java == 21 }} | |
| uses: actions/upload-artifact@ea165f8d65b6e75b540449e92b4886f43607fa02 # v4 | |
| with: | |
| name: jacoco-coverage-reports | |
| path: '**/build/reports/jacoco/test/jacocoTestReport.xml' | |
| retention-days: 1 | |
| if-no-files-found: error | |
| - name: Upload Artifacts | |
| if: ${{ matrix.test-type == 'unit' }} | |
| uses: actions/upload-artifact@ea165f8d65b6e75b540449e92b4886f43607fa02 # v4 | |
| continue-on-error: true | |
| with: | |
| name: opensearch-sql-ubuntu-latest-${{ matrix.java }} | |
| path: opensearch-sql-builds | |
| - name: Upload test reports | |
| if: ${{ always() }} | |
| uses: actions/upload-artifact@ea165f8d65b6e75b540449e92b4886f43607fa02 # v4 | |
| continue-on-error: true | |
| with: | |
| name: test-reports-ubuntu-latest-${{ matrix.java }}-${{ matrix.test-type }} | |
| path: | | |
| sql/build/reports/** | |
| ppl/build/reports/** | |
| core/build/reports/** | |
| common/build/reports/** | |
| opensearch/build/reports/** | |
| integ-test/build/reports/** | |
| protocol/build/reports/** | |
| legacy/build/reports/** | |
| plugin/build/reports/** | |
| doctest/build/testclusters/docTestCluster-0/logs/* | |
| integ-test/build/testclusters/*/logs/* | |
| upload-coverage: | |
| needs: build-linux | |
| name: Upload SQL coverage report to Codecov | |
| if: ${{ !cancelled() && github.repository == 'opensearch-project/sql' }} | |
| runs-on: ubuntu-latest | |
| steps: | |
| - uses: actions/checkout@34e114876b0b11c390a56381ad16ebd13914f8d5 # v4 | |
| - name: Download coverage reports | |
| id: download-coverage | |
| continue-on-error: true | |
| uses: actions/download-artifact@d3f86a106a0bac45b974a628896c90dbdf5c8093 # v4 | |
| with: | |
| name: jacoco-coverage-reports | |
| path: coverage | |
| - name: Upload SQL Coverage Report | |
| uses: codecov/codecov-action@fb8b3582c8e4def4969c97caa2f19720cb33a72f # v7.0.0 | |
| if: steps.download-coverage.outcome == 'success' | |
| with: | |
| flags: sql-engine | |
| directory: coverage | |
| token: ${{ secrets.CODECOV_TOKEN }} | |
| build-windows-macos: | |
| strategy: | |
| fail-fast: false | |
| matrix: | |
| entry: | |
| - { os: windows-latest, java: 21, os_build_args: -PbuildPlatform=windows } | |
| - { os: windows-latest, java: 25, os_build_args: -PbuildPlatform=windows } | |
| - { os: macos-14, java: 21, os_build_args: '' } | |
| - { os: macos-14, java: 25, os_build_args: '' } | |
| test-type: ['unit', 'integration', 'doc'] | |
| exclude: | |
| # Exclude doctest for Windows | |
| - test-type: doc | |
| entry: { os: windows-latest, java: 21, os_build_args: -PbuildPlatform=windows } | |
| - test-type: doc | |
| entry: { os: windows-latest, java: 25, os_build_args: -PbuildPlatform=windows } | |
| runs-on: ${{ matrix.entry.os }} | |
| steps: | |
| - uses: actions/checkout@34e114876b0b11c390a56381ad16ebd13914f8d5 # v4 | |
| - name: Set up JDK ${{ matrix.entry.java }} | |
| uses: actions/setup-java@c1e323688fd81a25caa38c78aa6df2d33d3e20d9 # v4 | |
| with: | |
| distribution: 'temurin' | |
| java-version: ${{ matrix.entry.java }} | |
| - name: Build and Test | |
| run: | | |
| if [ "${{ matrix.test-type }}" = "unit" ]; then | |
| ./gradlew --continue build -x integTest -x tracingIntegTest -x yamlRestTest -x doctest ${{ matrix.entry.os_build_args }} | |
| elif [ "${{ matrix.test-type }}" = "integration" ]; then | |
| ./gradlew --continue integTest tracingIntegTest yamlRestTest ${{ matrix.entry.os_build_args }} | |
| else | |
| ./gradlew --continue doctest ${{ matrix.entry.os_build_args }} | |
| fi | |
| shell: bash | |
| - name: Create Artifact Path | |
| if: ${{ matrix.test-type == 'unit' }} | |
| run: | | |
| mkdir -p opensearch-sql-builds | |
| cp -r ./plugin/build/distributions/*.zip opensearch-sql-builds/ | |
| - name: Upload Artifacts | |
| if: ${{ matrix.test-type == 'unit' }} | |
| uses: actions/upload-artifact@ea165f8d65b6e75b540449e92b4886f43607fa02 # v4 | |
| continue-on-error: true | |
| with: | |
| name: opensearch-sql-${{ matrix.entry.os }}-${{ matrix.entry.java }} | |
| path: opensearch-sql-builds | |
| - name: Upload test reports | |
| if: ${{ always() }} | |
| uses: actions/upload-artifact@ea165f8d65b6e75b540449e92b4886f43607fa02 # v4 | |
| continue-on-error: true | |
| with: | |
| name: test-reports-${{ matrix.entry.os }}-${{ matrix.entry.java }}-${{ matrix.test-type }} | |
| path: | | |
| sql/build/reports/** | |
| ppl/build/reports/** | |
| core/build/reports/** | |
| common/build/reports/** | |
| opensearch/build/reports/** | |
| integ-test/build/reports/** | |
| protocol/build/reports/** | |
| legacy/build/reports/** | |
| plugin/build/reports/** | |
| doctest/build/testclusters/docTestCluster-0/logs/* | |
| integ-test/build/testclusters/*/logs/* | |
| bwc-tests-rolling-upgrade: | |
| needs: Get-CI-Image-Tag | |
| runs-on: ubuntu-latest | |
| strategy: | |
| matrix: | |
| java: [21, 25] | |
| container: | |
| image: ${{ needs.Get-CI-Image-Tag.outputs.ci-image-version-linux }} | |
| options: ${{ needs.Get-CI-Image-Tag.outputs.ci-image-start-options }} | |
| steps: | |
| - name: Run start commands | |
| run: ${{ needs.Get-CI-Image-Tag.outputs.ci-image-start-command }} | |
| - uses: actions/checkout@34e114876b0b11c390a56381ad16ebd13914f8d5 # v4 | |
| - name: Set up JDK ${{ matrix.java }} | |
| uses: actions/setup-java@c1e323688fd81a25caa38c78aa6df2d33d3e20d9 # v4 | |
| with: | |
| distribution: 'temurin' | |
| java-version: ${{ matrix.java }} | |
| - name: Run backward compatibility tests in rolling upgrade | |
| run: | | |
| chown -R 1000:1000 `pwd` | |
| su `id -un 1000` -c "./scripts/bwctest-rolling-upgrade.sh" | |
| - name: Upload test reports | |
| if: ${{ always() }} | |
| uses: actions/upload-artifact@ea165f8d65b6e75b540449e92b4886f43607fa02 # v4 | |
| continue-on-error: true | |
| with: | |
| name: test-reports-ubuntu-latest-${{ matrix.java }}-bwc | |
| path: | | |
| sql/build/reports/** | |
| ppl/build/reports/** | |
| core/build/reports/** | |
| common/build/reports/** | |
| opensearch/build/reports/** | |
| integ-test/build/reports/** | |
| protocol/build/reports/** | |
| legacy/build/reports/** | |
| plugin/build/reports/** | |
| doctest/build/testclusters/docTestCluster-0/logs/* | |
| integ-test/build/testclusters/*/logs/* | |
| bwc-tests-full-restart: | |
| needs: Get-CI-Image-Tag | |
| runs-on: ubuntu-latest | |
| strategy: | |
| matrix: | |
| java: [21, 25] | |
| container: | |
| image: ${{ needs.Get-CI-Image-Tag.outputs.ci-image-version-linux }} | |
| options: ${{ needs.Get-CI-Image-Tag.outputs.ci-image-start-options }} | |
| steps: | |
| - name: Run start commands | |
| run: ${{ needs.Get-CI-Image-Tag.outputs.ci-image-start-command }} | |
| - uses: actions/checkout@34e114876b0b11c390a56381ad16ebd13914f8d5 # v4 | |
| - name: Set up JDK ${{ matrix.java }} | |
| uses: actions/setup-java@c1e323688fd81a25caa38c78aa6df2d33d3e20d9 # v4 | |
| with: | |
| distribution: 'temurin' | |
| java-version: ${{ matrix.java }} | |
| - name: Run backward compatibility tests in full restart | |
| run: | | |
| chown -R 1000:1000 `pwd` | |
| su `id -un 1000` -c "./scripts/bwctest-full-restart.sh" | |
| - name: Upload test reports | |
| if: ${{ always() }} | |
| uses: actions/upload-artifact@ea165f8d65b6e75b540449e92b4886f43607fa02 # v4 | |
| continue-on-error: true | |
| with: | |
| name: test-reports-ubuntu-latest-${{ matrix.java }}-bwc | |
| path: | | |
| sql/build/reports/** | |
| ppl/build/reports/** | |
| core/build/reports/** | |
| common/build/reports/** | |
| opensearch/build/reports/** | |
| integ-test/build/reports/** | |
| protocol/build/reports/** | |
| legacy/build/reports/** | |
| plugin/build/reports/** | |
| doctest/build/testclusters/docTestCluster-0/logs/* | |
| integ-test/build/testclusters/*/logs/* |