fix: treat Array Brackets [..] as syntax characters and surround by space when normalizing for comparison

manticore-projects · manticore-projects · commit c9d1eaefca91 · 2024-03-26T09:38:04.000+07:00
Signed-off-by: Andreas Reichel &lt;andreas@manticore-projects.com&gt;
diff --git a/src/test/java/net/sf/jsqlparser/test/TestUtils.java b/src/test/java/net/sf/jsqlparser/test/TestUtils.java
@@ -59,7 +59,7 @@ public class TestUtils {
 
     // Assure SPACE around Syntax Characters
     private static final Pattern SQL_SANITATION_PATTERN2 =
-            Pattern.compile("\\s*([!/,()=+\\-*|\\]<>:])\\s*", Pattern.MULTILINE);
+            Pattern.compile("\\s*([!/,()=+\\-*|\\]<>:\\[\\]])\\s*", Pattern.MULTILINE);
 
     /**
      * @param statement
