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

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.22.0
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: Anton Haidai
• Created: 03/Jan/20 16:05
• Updated: 06/Mar/20 04:36
• Resolved: 13/Jan/20 04:23

Description

Reproducible in master (06ac187a342f82a4b69e4c752ccdce0c269a350d): 1.22.0-SNAPSHOT

SqlToRelConverterTest:

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

Error:

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]])

Issue Links

• links to: GitHub Pull Request #1724