[SQLite] Also prevent generating UNION clauses with affinities in views when using PQS

mrigger · mrigger · commit e1c4a21cfa58 · 2020-08-26T17:23:32.000+02:00
diff --git a/src/sqlancer/sqlite3/gen/ddl/SQLite3ViewGenerator.java b/src/sqlancer/sqlite3/gen/ddl/SQLite3ViewGenerator.java
@@ -76,8 +76,10 @@ private static boolean checkAffinity(SQLite3Expression randomQuery) {
                     return false;
                 }
             }
+            return true;
+        } else {
+            return false; // the columns in UNION clauses can also have affinities
         }
-        return true;
     }
 
     private static void columnNamesAs(StringBuilder sb, int size) {

Original file line number	Diff line number	Diff line change
`@@ -76,8 +76,10 @@ private static boolean checkAffinity(SQLite3Expression randomQuery) {`
`76`	`76`	`return false;`
`77`	`77`	`}`
`78`	`78`	`}`
	`79`	`+ return true;`
	`80`	`+ } else {`
	`81`	`+ return false; // the columns in UNION clauses can also have affinities`
`79`	`82`	`}`
`80`		`- return true;`
`81`	`83`	`}`
`82`	`84`
`83`	`85`	`private static void columnNamesAs(StringBuilder sb, int size) {`