[jira] [Created] (CALCITE-3675) SQL to Rel conversion is broken for coalesce on nullable field

["Anton Haidai (Jira)" <ji...@apache.org>]

Anton Haidai created CALCITE-3675:
-------------------------------------

             Summary: SQL to Rel conversion is broken for coalesce on nullable field
                 Key: CALCITE-3675
                 URL: https://issues.apache.org/jira/browse/CALCITE-3675
             Project: Calcite
          Issue Type: Bug
    Affects Versions: next
            Reporter: Anton Haidai


Reproducible in master (06ac187a342f82a4b69e4c752ccdce0c269a350d): 1.22.0-SNAPSHOT

SqlToRelConverterTest:
{code}
  @Test public void testCoalesceOnNullableField() {
    final String sql = "select coalesce(mgr, 0) from emp";
    sql(sql).ok();
  }
{code}

Error:
{code}
Conversion to relational algebra failed to preserve datatypes:
validated type:
RecordType(INTEGER NOT NULL EXPR$0) NOT NULL
converted type:
RecordType(INTEGER EXPR$0) NOT NULL
rel:
LogicalProject(EXPR$0=[CASE(IS NOT NULL($3), $3, 0)])
  LogicalTableScan(table=[[CATALOG, SALES, EMP]])
{code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)