[jira] [Created] (CALCITE-5042) Incorrect syntax in sub-query

["Roman Churganov (Jira)" <ji...@apache.org>]

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)