fix(calcite): sort/sort-expr pushdown on text fields must use the key… #357
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@c2498b758c08fb7bc48476509a5fc1b8dd5f7493 # 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 yamlRestTest -x doctest" | |
| elif [ "${{ matrix.test-type }}" = "integration" ]; then | |
| su `id -un 1000` -c "./gradlew --continue integTest 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 | |
| if: ${{ always() }} | |
| uses: codecov/codecov-action@b9fd7d16f6d7d1b5d2bec1a2887e65ceed900238 # v4 | |
| continue-on-error: true | |
| with: | |
| flags: sql-engine | |
| token: ${{ secrets.CODECOV_TOKEN }} | |
| - 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/* | |
| 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 yamlRestTest -x doctest ${{ matrix.entry.os_build_args }} | |
| elif [ "${{ matrix.test-type }}" = "integration" ]; then | |
| ./gradlew --continue integTest 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 SQL Coverage Report | |
| if: ${{ always() && matrix.entry.os == 'ubuntu-latest' }} | |
| uses: codecov/codecov-action@b9fd7d16f6d7d1b5d2bec1a2887e65ceed900238 # v4 | |
| continue-on-error: true | |
| with: | |
| flags: sql-engine | |
| token: ${{ secrets.CODECOV_TOKEN }} | |
| - 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/* |