You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Danny Chen (Jira)" <ji...@apache.org> on 2020/04/17 01:29:00 UTC
[jira] [Resolved] (CALCITE-3894) SET operation between DATE and
TIMESTAMP returns a wrong result
[ https://issues.apache.org/jira/browse/CALCITE-3894?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Danny Chen resolved CALCITE-3894.
---------------------------------
Fix Version/s: 1.23.0
Assignee: Danny Chen (was: TANG Wen-hui)
Resolution: Fixed
Fixed in [2798d90|https://github.com/apache/calcite/commit/2798d90a8082adb294c3aadbad6d22d9228abf3e] !
> SET operation between DATE and 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: Danny Chen
> Priority: Major
> Labels: pull-request-available
> Fix For: 1.23.0
>
> Time Spent: 1h 10m
> Remaining Estimate: 0h
>
> {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)