Update H2 to make it work with recent changes

mrigger · mrigger · commit a3a8821588d5 · 2020-12-13T20:21:56.000+01:00
diff --git a/.github/workflows/main.yml b/.github/workflows/main.yml
@@ -229,6 +229,8 @@ jobs:
           git clone https://github.com/h2database/h2database
           cd h2database/h2
           ./build.sh jar
-          cp bin/h2*.jar ../../target/lib/h2*.jar
+          cp bin/h2-2.0.201.jar ../../target/lib/h2-1.4.200.jar
+          cp bin/h2-2.0.201.jar ~/.m2/repository/com/h2database/h2/1.4.200/h2-1.4.200.jar
+          ls -lh ../../target/lib
       - name: Run Tests
         run: H2_AVAILABLE=true mvn -Dtest=TestH2 test
diff --git a/src/sqlancer/h2/H2Errors.java b/src/sqlancer/h2/H2Errors.java
@@ -19,6 +19,8 @@ public static void addInsertErrors(ExpectedErrors errors) {
     }
 
     public static void addExpressionErrors(ExpectedErrors errors) {
+        errors.add("java.lang.ArithmeticException: BigInteger would overflow supported range");
+        errors.add("Value too long for column");
         errors.add("Numeric value out of range");
         errors.add("are not comparable");
         errors.add("Data conversion error converting");
diff --git a/src/sqlancer/h2/H2SetGenerator.java b/src/sqlancer/h2/H2SetGenerator.java
@@ -25,7 +25,7 @@ private enum Option {
         DEFAULT_NULL_ORDERING((r) -> Randomly.fromOptions("LOW", "HIGH", "FIRST", "LAST")), //
         DEFAULT_TABLE_TYPE((r) -> Randomly.fromOptions("MEMORY", "CACHED")), //
         IGNORECASE((r) -> Randomly.fromOptions("TRUE", "FALSE")), //
-        LAZY_QUERY_EXECUTION((r) -> Randomly.fromOptions(0, 1)), LOG((r) -> Randomly.fromOptions(0, 1, 2)), //
+        LAZY_QUERY_EXECUTION((r) -> Randomly.fromOptions(0, 1)), //
         MAX_MEMORY_ROWS((r) -> Randomly.getNotCachedInteger(0, 100000)), //
         MAX_MEMORY_UNDO((r) -> Randomly.getNotCachedInteger(0, 100000)), //
         MAX_OPERATION_MEMORY((r) -> Randomly.getNotCachedInteger(0, 100000)), //

Original file line number	Diff line number	Diff line change
`@@ -19,6 +19,8 @@ public static void addInsertErrors(ExpectedErrors errors) {`
`19`	`19`	`}`
`20`	`20`
`21`	`21`	`public static void addExpressionErrors(ExpectedErrors errors) {`
	`22`	`+ errors.add("java.lang.ArithmeticException: BigInteger would overflow supported range");`
	`23`	`+ errors.add("Value too long for column");`
`22`	`24`	`errors.add("Numeric value out of range");`
`23`	`25`	`errors.add("are not comparable");`
`24`	`26`	`errors.add("Data conversion error converting");`