Use GitHub Actions to test MariaDB

mrigger · mrigger · commit 890a0aef663d · 2020-12-12T23:52:10.000+01:00
diff --git a/.github/workflows/main.yml b/.github/workflows/main.yml
@@ -63,3 +63,29 @@ jobs:
         run: mvn -B package -DskipTests=true
       - name: DuckDB Tests
         run: mvn -Dtest=TestDuckDB test
+
+  mariadb:
+    name: MariaDB Tests
+    runs-on: ubuntu-latest
+
+    steps:
+      - uses: actions/checkout@v2
+        with:
+          fetch-depth: 0
+      - name: Set up JDK 1.8
+        uses: actions/setup-java@v1
+        with:
+          java-version: 1.8
+      - name: Build SQLancer
+        run: mvn -B package -DskipTests=true
+      - name: Install MariaDB
+        run: |
+          sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8
+          sudo add-apt-repository 'deb [arch=amd64,arm64,ppc64el] http://sfo1.mirrors.digitalocean.com/mariadb/repo/10.3/ubuntu bionic main'
+          sudo apt update
+          sudo apt install mariadb-server
+          sudo systemctl start mariadb
+      - name: Create SQLancer User
+        run: sudo mysql -uroot -proot -e "CREATE USER 'sqlancer'@'localhost' IDENTIFIED BY 'sqlancer'; GRANT ALL PRIVILEGES ON * . * TO 'sqlancer'@'localhost';"
+      - name: Run Tests
+        run: MARIADB_AVAILABLE=true mvn -Dtest=TestMariaDB test
