[KYLIN-2329] Between 0.06 - 0.01 and 0.06 + 0.01, returns incorrect result

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: v2.0.0
• Assignee: Kaige Liu
• Reporter: liyang
• Created: 28/Dec/16 10:15
• Updated: 30/Apr/17 12:21
• Resolved: 07/Feb/17 07:09

Description

A TPC-H query returns incorrect result:

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;

The result becomes correct if change condition to below

    and l_discount between 0.05 and 0.07

Issue Links

• is related to: KYLIN-2467 TPC-H queries run on Kylin