You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@kylin.apache.org by "liyang (JIRA)" <ji...@apache.org> on 2017/02/07 07:09:41 UTC

[jira] [Resolved] (KYLIN-2329) Between 0.06 - 0.01 and 0.06 + 0.01, returns incorrect result

     [ https://issues.apache.org/jira/browse/KYLIN-2329?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

liyang resolved KYLIN-2329.
---------------------------
       Resolution: Fixed
    Fix Version/s: v2.0.0

> Between 0.06 - 0.01 and 0.06 + 0.01, returns incorrect result
> -------------------------------------------------------------
>
>                 Key: KYLIN-2329
>                 URL: https://issues.apache.org/jira/browse/KYLIN-2329
>             Project: Kylin
>          Issue Type: Bug
>            Reporter: liyang
>            Assignee:  Kaige Liu
>             Fix For: v2.0.0
>
>
> A TPC-H query returns incorrect result:
> {code}
> select
>     sum(l_saleprice) as revenue
> from
>     v_lineitem
> where
>     l_shipdate >= '1993-01-01'
>     and l_shipdate < '1994-01-01'
>     and l_discount between 0.06 - 0.01 and 0.06 + 0.01
>     and l_quantity < 25;
> {code}
> The result becomes correct if change condition to below
> {code}
>     and l_discount between 0.05 and 0.07
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)