Roman Churganov created CALCITE-5042: ----------------------------------------
Summary: Incorrect syntax in sub-query Key: CALCITE-5042 URL: https://issues.apache.org/jira/browse/CALCITE-5042 Project: Calcite Issue Type: Bug Reporter: Roman Churganov Fix For: 1.30.0 When run during the build ({{./gradlew clean build}}) the test fails intermittently but when it is executed individually it always fails. {code:bash} ./gradlew cleanTest :core:test --tests SqlTypeFactoryTest.testUnknownCreateWithNullabilityTypeConsistency {code} Stacktrace {noformat} java.lang.AssertionError: Expected: is an instance of org.apache.calcite.sql.type.SqlTypeFactoryImpl$UnknownSqlType but: <UNKNOWN> is a org.apache.calcite.sql.type.BasicSqlType at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.sql.type.SqlTypeFactoryTest.testUnknownCreateWithNullabilityTypeConsistency(SqlTypeFactoryTest.java:296) {noformat} Due to type canonization in [RelDataTypeFactory|https://github.com/apache/calcite/blob/170035fd97df1afdd0c0a499f63e0ca1606f7837/core/src/main/java/org/apache/calcite/rel/type/RelDataTypeFactoryImpl.java#L405] the class of the created type is not the expected one. -- This message was sent by Atlassian Jira (v8.20.1#820001)