[ https://issues.apache.org/jira/browse/CALCITE-2290?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Stamatis Zampetakis updated CALCITE-2290: ----------------------------------------- Labels: pull-request-available (was: ) > Type mismatch during flattening > ------------------------------- > > Key: CALCITE-2290 > URL: https://issues.apache.org/jira/browse/CALCITE-2290 > Project: Calcite > Issue Type: Bug > Components: core > Reporter: Laurent Goujon > Priority: Major > Labels: pull-request-available > > The following query causes Calcite not being able to perform SQL to Rel > conversion: > {code:sql} > select (res1 = 'qwe') res2 from (select (case when (false) then null else > 'qwe' end) res1 from (values(1))) > {code} > > While adding the query to {{SqlToRelConverTest}}, the test generates the > following output: > {noformat} > java.lang.AssertionError: > type mismatch: > ref: > CHAR(3) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" > input: > CHAR(3) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL > at > org.apache.calcite.test.SqlToRelConverterTest.testCaseFlatten(SqlToRelConverterTest.java:2786) > {noformat} -- This message was sent by Atlassian JIRA (v7.6.3#76005)