[SQLite] Ensure that the PQS subquery string does not end with a semicolon

mrigger · mrigger · commit af93a55176f2 · 2020-08-23T00:01:07.000+02:00
diff --git a/src/sqlancer/sqlite3/oracle/SQLite3PivotedQuerySynthesisOracle.java b/src/sqlancer/sqlite3/oracle/SQLite3PivotedQuerySynthesisOracle.java
@@ -185,7 +185,11 @@ protected boolean isContainedIn(Query query) throws SQLException {
         StringBuilder sb2 = new StringBuilder();
         addExpectedValues(sb2);
         sb.append(" INTERSECT SELECT * FROM ("); // ANOTHER SELECT TO USE ORDER BY without restrictions
-        sb.append(query.getQueryString());
+        if (query.getQueryString().endsWith(";")) {
+            sb.append(query.getQueryString().substring(0, query.getQueryString().length() - 1));
+        } else {
+            sb.append(query.getQueryString());
+        }
         sb.append(")");
         String resultingQueryString = sb.toString();
         Query finalQuery = new QueryAdapter(resultingQueryString, query.getExpectedErrors());
