[CALCITE-2290] Type mismatch during flattening

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Not A Problem
• Fix Version/s: 1.19.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: Laurent Goujon
• Created: 30/Apr/18 18:44
• Updated: 27/Feb/19 23:28
• Resolved: 27/Feb/19 23:28

Description

The following query causes Calcite not being able to perform SQL to Rel conversion:

select (res1 = 'qwe') res2 from (select (case when (false) then null else 'qwe' end) res1 from (values(1)))

 
While adding the query to SqlToRelConverTest, the test generates the following output:

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)

Issue Links

• links to: GitHub Pull Request #708
• links to: PR#708