test: add unit test for issue #1778

manticore-projects · manticore-projects · commit decf662f1b22 · 2023-05-11T20:01:18.000+07: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
@@ -5779,4 +5779,13 @@ void testInnerJoin() throws JSQLParserException {
         assertFalse(join.withRight(true).isInnerJoin());
         assertFalse(join.withInner(true).isRight());
     }
+
+    @Test
+    void testArrayColumnsIssue1757() throws JSQLParserException {
+        String sqlStr = "SELECT my_map['my_key'] FROM my_table WHERE id = 123";
+        assertSqlCanBeParsedAndDeparsed(sqlStr, true);
+
+        sqlStr = "SELECT cast(my_map['my_key'] as int) FROM my_table WHERE id = 123";
+        assertSqlCanBeParsedAndDeparsed(sqlStr, true);
+    }
 }
diff --git a/src/test/java/net/sf/jsqlparser/statement/update/UpdateTest.java b/src/test/java/net/sf/jsqlparser/statement/update/UpdateTest.java
@@ -341,7 +341,7 @@ public void testUpdateSetsIssue1590() throws JSQLParserException {
     }
 
     @Test
-    void testIssue() throws JSQLParserException {
+    void testArrayColumnsIssue1083() throws JSQLParserException {
         String sqlStr = "SELECT listes[(SELECT cardinality(listes))]";
         assertSqlCanBeParsedAndDeparsed(sqlStr, true);
 

Original file line number	Diff line number	Diff line change
`@@ -5779,4 +5779,13 @@ void testInnerJoin() throws JSQLParserException {`
`5779`	`5779`	`assertFalse(join.withRight(true).isInnerJoin());`
`5780`	`5780`	`assertFalse(join.withInner(true).isRight());`
`5781`	`5781`	`}`
	`5782`	`+`
	`5783`	`+ @Test`
	`5784`	`+ void testArrayColumnsIssue1757() throws JSQLParserException {`
	`5785`	`+ String sqlStr = "SELECT my_map['my_key'] FROM my_table WHERE id = 123";`
	`5786`	`+ assertSqlCanBeParsedAndDeparsed(sqlStr, true);`
	`5787`	`+`
	`5788`	`+ sqlStr = "SELECT cast(my_map['my_key'] as int) FROM my_table WHERE id = 123";`
	`5789`	`+ assertSqlCanBeParsedAndDeparsed(sqlStr, true);`
	`5790`	`+ }`
`5782`	`5791`	`}`
Original file line number	Diff line number	Diff line change
`@@ -341,7 +341,7 @@ public void testUpdateSetsIssue1590() throws JSQLParserException {`
`341`	`341`	`}`
`342`	`342`
`343`	`343`	`@Test`
`344`		`- void testIssue() throws JSQLParserException {`
	`344`	`+ void testArrayColumnsIssue1083() throws JSQLParserException {`
`345`	`345`	`String sqlStr = "SELECT listes[(SELECT cardinality(listes))]";`
`346`	`346`	`assertSqlCanBeParsedAndDeparsed(sqlStr, true);`
`347`	`347`