[ https://issues.apache.org/jira/browse/CALCITE-2290?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16737210#comment-16737210 ]
Vladimir Sitnikov commented on CALCITE-2290: -------------------------------------------- [~laurentgo], the test case no longer fails in Calcite 1.19.0-SNAPSHOT. Would you please check if the bug is still present? > 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 > Assignee: Julian Hyde > Priority: Major > > 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)