Skip to content

[Backport 2.x] Resolve Alias Issues in Legacy SQL with Filters (#3059) #8008

[Backport 2.x] Resolve Alias Issues in Legacy SQL with Filters (#3059)

[Backport 2.x] Resolve Alias Issues in Legacy SQL with Filters (#3059) #8008

name: SQL Java CI
on:
pull_request:
push:
branches-ignore:
- 'dependabot/**'
paths:
- '**/*.java'
- '**/*.g4'
- '!sql-jdbc/**'
- '**gradle*'
- '**lombok*'
- '**spotless*'
- 'integ-test/**'
- '**/*.jar'
- '**/*.pom'
- '.github/workflows/sql-test-and-build-workflow.yml'
jobs:
Get-CI-Image-Tag:
uses: opensearch-project/opensearch-build/.github/workflows/get-ci-image-tag.yml@main
with:
product: opensearch
build-linux:
needs: Get-CI-Image-Tag
strategy:
# Run all jobs
fail-fast: false
matrix:
java:
- 11
- 17
- 21
env:
ACTIONS_ALLOW_USE_UNSECURE_NODE_VERSION: true
runs-on: ubuntu-latest
container:
# using the same image which is used by opensearch-build team to build the OpenSearch Distribution
# this image tag is subject to change as more dependencies and updates will arrive over time
image: ${{ needs.Get-CI-Image-Tag.outputs.ci-image-version-linux }}
# need to switch to root so that github actions can install runner binary on container without permission issues.
options: --user root
steps:
- uses: actions/checkout@v3
- name: Set up JDK ${{ matrix.java }}
uses: actions/setup-java@v3
with:
distribution: 'temurin'
java-version: ${{ matrix.java }}
- name: Build with Gradle
run: |
chown -R 1000:1000 `pwd`
su `id -un 1000` -c "./gradlew --continue build"
- name: Run backward compatibility tests
run: |
chown -R 1000:1000 `pwd`
su `id -un 1000` -c "./scripts/bwctest.sh"
- name: Create Artifact Path
run: |
mkdir -p opensearch-sql-builds
cp -r ./plugin/build/distributions/*.zip opensearch-sql-builds/
# This step uses the codecov-action Github action: https://github.com/codecov/codecov-action
- name: Upload SQL Coverage Report
if: always()
uses: codecov/codecov-action@v3
with:
flags: sql-engine
token: ${{ secrets.CODECOV_TOKEN }}
- name: Upload Artifacts
uses: actions/upload-artifact@v3
with:
name: opensearch-sql-ubuntu-latest
path: opensearch-sql-builds
- name: Upload test reports
if: always()
uses: actions/upload-artifact@v3
continue-on-error: true
with:
name: test-reports
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/**
build-windows-macos:
strategy:
# Run all jobs
fail-fast: false
matrix:
entry:
- { os: windows-latest, java: 11, os_build_args: -x doctest -PbuildPlatform=windows }
- { os: macos-13, java: 11}
- { os: windows-latest, java: 17, os_build_args: -x doctest -PbuildPlatform=windows }
- { os: macos-13, java: 17 }
- { os: windows-latest, java: 21, os_build_args: -x doctest -PbuildPlatform=windows }
- { os: macos-13, java: 21 }
runs-on: ${{ matrix.entry.os }}
steps:
- uses: actions/checkout@v3
- name: Set up JDK ${{ matrix.java }}
uses: actions/setup-java@v3
with:
distribution: 'temurin'
java-version: ${{ matrix.entry.java }}
- name: Build with Gradle
run: ./gradlew --continue build ${{ matrix.entry.os_build_args }}
- name: Create Artifact Path
run: |
mkdir -p opensearch-sql-builds
cp -r ./plugin/build/distributions/*.zip opensearch-sql-builds/
- name: Upload Artifacts
uses: actions/upload-artifact@v3
with:
name: opensearch-sql-${{ matrix.entry.os }}
path: opensearch-sql-builds