[CALCITE-2938] Druid adapter do wrong behavior for casts from timestamp type to date type

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.19.0
• Component/s: druid-adapter
• Assignee: Danny Chen
• Reporter: Danny Chen
• Due: 16/Feb/19
• Created: 20/Mar/19 12:54
• Updated: 27/May/19 17:18

Description

For sql like

Select cast("timestamp" as date) as t from "foodmart" order by t limit 1

It produces results:
3242-06-03
while it expects to be:
1997-01-01

You can past the code

@Test
  public void testCastTimestamp() {
    final String sql = "Select cast(\"timestamp\" as date) as t"
        + " from \"foodmart\" order by t limit 1";

    sql(sql, FOODMART)
        .returnsOrdered("T=1997-01-01 00:00:00")
        .queryContains(
            druidChecker("UTC"));
  }

in DruidAdapterIT2 and reproduce it.