wumpz · wumpz · commit 002f5966c577 · 2021-05-01T21:57:10.000+02:00
diff --git a/src/test/java/net/sf/jsqlparser/statement/select/SelectTest.java b/src/test/java/net/sf/jsqlparser/statement/select/SelectTest.java
@@ -4495,4 +4495,14 @@ public void testKeywordAlgorithmIssue1137() throws JSQLParserException {
     public void testKeywordAlgorithmIssue1138() throws JSQLParserException {
         assertSqlCanBeParsedAndDeparsed("SELECT * FROM in.tablename");
     }
+    
+    @Test
+    public void testProblematicDeparsingIssue1183() throws JSQLParserException {
+        assertSqlCanBeParsedAndDeparsed("SELECT ARRAY_AGG(NAME) FILTER (WHERE NAME IS NOT NULL)");
+    }
+    
+    @Test
+    public void testProblematicDeparsingIssue1183_2() throws JSQLParserException {
+        assertSqlCanBeParsedAndDeparsed("SELECT ARRAY_AGG(ID ORDER BY ID) OVER (ORDER BY ID)");
+    }
 }
