Laurent Goujon created CALCITE-2290: ---------------------------------------
Summary: 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 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)