YiwenWu commented on code in PR #3698:
URL: https://github.com/apache/calcite/pull/3698#discussion_r1497598755
##########
server/src/test/java/org/apache/calcite/test/ServerParserTest.java:
##########
@@ -116,6 +115,30 @@ class ServerParserTest extends SqlParserTest {
.ok("CREATE TABLE `X` (`I` INTEGER NOT NULL, `J` VARCHAR(5))");
}
+ /**
+ * Test case for <a
href="https://issues.apache.org/jira/browse/CALCITE-6275";>[CALCITE-6275]
+ * Parser for data types ignores element nullability in collections</a>. */
+ @Test void testCreateTableWithArray() {
+ sql("create table x ("
+ + "a int array, "
+ + "b int array not null, "
+ + "c int not null array, "
+ + "d int not null array not null, "
+ + "e int array null, " // same as column a
+ + "f int null array null, " // same as column a
+ + "g int null array not null, " // same as column b
+ + "h int not null array null)") // same as column c
+ .ok("CREATE TABLE `X` ("
+ + "`A` INTEGER ARRAY, "
+ + "`B` INTEGER ARRAY NOT NULL, "
+ + "`C` INTEGER NOT NULL ARRAY, "
Review Comment:
Is `INTEGER NOT NULL ARRAY`supported in Postgresql?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
