TANG Wen-hui created CALCITE-3894:
-------------------------------------
Summary: The Union operation between DATE with TIMESTAMP returns a
wrong result
Key: CALCITE-3894
URL: https://issues.apache.org/jira/browse/CALCITE-3894
Project: Calcite
Issue Type: Bug
Reporter: TANG Wen-hui
Assignee: TANG Wen-hui
{code:java}
@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");
}{code}
The test with wrong result passed.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
