fix: temp table generation (#653)

bajinsheng · web-flow · commit a53552076680 · 2022-12-17T21:22:32.000+08:00
diff --git a/src/sqlancer/sqlite3/gen/ddl/SQLite3ViewGenerator.java b/src/sqlancer/sqlite3/gen/ddl/SQLite3ViewGenerator.java
@@ -31,7 +31,7 @@ public static SQLQueryAdapter dropView(SQLite3GlobalState globalState) {
     public static SQLQueryAdapter generate(SQLite3GlobalState globalState) throws SQLException {
         StringBuilder sb = new StringBuilder();
         sb.append("CREATE");
-        if (Randomly.getBoolean()) {
+        if (globalState.getDbmsSpecificOptions().testTempTables && Randomly.getBoolean()) {
             sb.append(" ");
             sb.append(Randomly.fromOptions("TEMP", "TEMPORARY"));
         }

Original file line number	Diff line number	Diff line change
`@@ -31,7 +31,7 @@ public static SQLQueryAdapter dropView(SQLite3GlobalState globalState) {`
`31`	`31`	`public static SQLQueryAdapter generate(SQLite3GlobalState globalState) throws SQLException {`
`32`	`32`	`StringBuilder sb = new StringBuilder();`
`33`	`33`	`sb.append("CREATE");`
`34`		`- if (Randomly.getBoolean()) {`
	`34`	`+ if (globalState.getDbmsSpecificOptions().testTempTables && Randomly.getBoolean()) {`
`35`	`35`	`sb.append(" ");`
`36`	`36`	`sb.append(Randomly.fromOptions("TEMP", "TEMPORARY"));`
`37`	`37`	`}`