Test H2 using GitHub Actions

mrigger · mrigger · commit 5f2055da2123 · 2020-12-13T18:18:03.000+01:00
diff --git a/.github/workflows/main.yml b/.github/workflows/main.yml
@@ -210,3 +210,25 @@ jobs:
         run: mvn -B package -DskipTests=true
       - name: Run Tests
         run: POSTGRES_AVAILABLE=true mvn -Dtest=TestPostgres test
+
+  h2:
+    name: H2 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: Set up H2
+        run: |
+          git clone https://github.com/h2database/h2database
+          cd h2database/h2
+          ./build.sh jar
+          cp bin/h2*.jar ../../target/lib/h2*.jar
+      - name: Run Tests
+        run: H2_AVAILABLE=true mvn -Dtest=TestH2 test
diff --git a/test/sqlancer/dbms/TestH2.java b/test/sqlancer/dbms/TestH2.java
@@ -0,0 +1,22 @@
+package sqlancer.dbms;
+
+import static org.junit.jupiter.api.Assertions.assertEquals;
+import static org.junit.jupiter.api.Assumptions.assumeTrue;
+
+import org.junit.jupiter.api.Test;
+
+import sqlancer.Main;
+
+public class TestH2 {
+
+    @Test
+    public void testDuckDB() {
+        String h2Available = System.getenv("H2_AVAILABLE");
+        boolean mariaDBIsAvailable = h2Available != null && h2Available.equalsIgnoreCase("true");
+        assumeTrue(mariaDBIsAvailable);
+        assertEquals(0, Main.executeMain(new String[] { "--random-seed", "0", "--timeout-seconds", TestConfig.SECONDS,
+                "--num-threads", "4", "--num-queries", TestConfig.NUM_QUERIES, "h2" }));
+
+    }
+
+}
