[ 
https://issues.apache.org/jira/browse/CALCITE-2290?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Stamatis Zampetakis closed CALCITE-2290.
----------------------------------------
       Resolution: Not A Problem
    Fix Version/s: 1.19.0

Test no longer fails and [~laurentgo] didn't follow up so I am closing this 
issue.

> 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
>             Fix For: 1.19.0
>
>          Time Spent: 20m
>  Remaining Estimate: 0h
>
> 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)

Reply via email to