fix bug in CREATE TABLE

bajinsheng · bajinsheng · commit f3f44c313fb7 · 2022-12-16T17:03:50.000+08:00
diff --git a/src/sqlancer/common/query/SQLQueryAdapter.java b/src/sqlancer/common/query/SQLQueryAdapter.java
@@ -46,7 +46,7 @@ private String canonicalizeString(String s) {
     }
 
     private void checkQueryString() {
-        if (query.contains("CREATE TABLE") && !couldAffectSchema) {
+        if (query.contains("CREATE TABLE") && !query.startsWith("EXPLAIN") && !couldAffectSchema) {
             throw new AssertionError("CREATE TABLE statements should set couldAffectSchema to true");
         }
     }

Original file line number	Diff line number	Diff line change
`@@ -46,7 +46,7 @@ private String canonicalizeString(String s) {`
`46`	`46`	`}`
`47`	`47`
`48`	`48`	`private void checkQueryString() {`
`49`		`- if (query.contains("CREATE TABLE") && !couldAffectSchema) {`
	`49`	`+ if (query.contains("CREATE TABLE") && !query.startsWith("EXPLAIN") && !couldAffectSchema) {`
`50`	`50`	`throw new AssertionError("CREATE TABLE statements should set couldAffectSchema to true");`
`51`	`51`	`}`
`52`	`52`	`}`