[CALCITE-3894] SET operation between DATE and TIMESTAMP returns a wrong result

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.23.0
• Labels: pull-request-available
• Assignee: Danny Chen
• Reporter: TANG Wen-hui
• Created: 03/Apr/20 07:22
• Updated: 24/May/20 11:59
• Resolved: 17/Apr/20 01:28

Description

@Test public void testUnionTime() {
 CalciteAssert.AssertThat assertThat = CalciteAssert.that();
 String query = "select * from (\n"
 + "select \"id\" from (VALUES(DATE '2018-02-03')) \"foo\"(\"id\")\n"
 + "union\n"
 + "select \"id\" from (VALUES(TIMESTAMP '2008-03-31 12:23:34')) \"foo\"(\"id\"))";
 assertThat.query(query).returns("id=2108-03-12\nid=2018-02-03\n");
}

The test with wrong result passed.

 

Issue Links

• links to: GitHub Pull Request #1919
• links to: GitHub Pull Request #1920