Remove unused code to generate PQS debug information

mrigger · mrigger · commit 1231dfe487ee · 2020-08-27T19:07:49.000+02:00
diff --git a/src/sqlancer/mysql/oracle/MySQLPivotedQuerySynthesisOracle.java b/src/sqlancer/mysql/oracle/MySQLPivotedQuerySynthesisOracle.java
@@ -75,26 +75,6 @@ public Query getQueryThatContainsAtLeastOneRow() throws SQLException {
                 .generateOrderBys();
         selectStatement.setOrderByExpressions(orderBy);
 
-        StringBuilder sb2 = new StringBuilder();
-        sb2.append("SELECT * FROM (SELECT 1 FROM ");
-        sb2.append(randomFromTables.tableNamesAsString());
-        sb2.append(" WHERE ");
-        int i = 0;
-        for (MySQLColumn c : columns) {
-            if (i++ != 0) {
-                sb2.append(" AND ");
-            }
-            sb2.append("ref");
-            sb2.append(i - 1);
-            if (pivotRow.getValues().get(c).isNull()) {
-                sb2.append(" IS NULL");
-            } else {
-                sb2.append(" = ");
-                sb2.append(pivotRow.getValues().get(c).getTextRepresentation());
-            }
-        }
-        sb2.append(") as result;");
-
         MySQLToStringVisitor visitor = new MySQLToStringVisitor();
         visitor.visit(selectStatement);
         return new QueryAdapter(visitor.get(), errors);
diff --git a/src/sqlancer/postgres/oracle/PostgresPivotedQuerySynthesisOracle.java b/src/sqlancer/postgres/oracle/PostgresPivotedQuerySynthesisOracle.java
@@ -75,26 +75,6 @@ public Query getQueryThatContainsAtLeastOneRow() throws SQLException {
         List<PostgresExpression> orderBy = new PostgresExpressionGenerator(globalState).setColumns(columns)
                 .generateOrderBy();
         selectStatement.setOrderByExpressions(orderBy);
-
-        StringBuilder sb2 = new StringBuilder();
-        sb2.append("SELECT * FROM (SELECT 1 FROM ");
-        sb2.append(randomFromTables.tableNamesAsString());
-        sb2.append(" WHERE ");
-        int i = 0;
-        for (PostgresColumn c : fetchColumns) {
-            if (i++ != 0) {
-                sb2.append(" AND ");
-            }
-            sb2.append(c.getFullQualifiedName());
-            if (pivotRow.getValues().get(c).isNull()) {
-                sb2.append(" IS NULL");
-            } else {
-                sb2.append(" = ");
-                sb2.append(pivotRow.getValues().get(c).getTextRepresentation());
-            }
-        }
-        sb2.append(") as result;");
-
         PostgresToStringVisitor visitor = new PostgresToStringVisitor();
         visitor.visit(selectStatement);
         return new QueryAdapter(visitor.get());
