[jira] [Created] (TAJO-1789) 'BETWEEN a AND b' clause has a bug

["Dongkyu Hwangbo (JIRA)" <ji...@apache.org>]

Dongkyu Hwangbo created TAJO-1789:
-------------------------------------

             Summary: 'BETWEEN a AND b' clause has a bug
                 Key: TAJO-1789
                 URL: https://issues.apache.org/jira/browse/TAJO-1789
             Project: Tajo
          Issue Type: Bug
            Reporter: Dongkyu Hwangbo


This is TPC-H q6 in TPC-H Reference document.
{code:SQL}
select
sum(l_extendedprice*l_discount) as revenue
from
lineitem
where
l_shipdate >= date '1994-01-01'
and l_shipdate < date '1995-01-01'
and l_discount between 0.06 - 0.01 and 0.06 + 0.01
and l_quantity < 24;
{code}
look this line.
{code:SQL}
and l_discount between 0.06 - 0.01 and 0.06 + 0.01
{code}
this line make a wrong answer.

Replaced line
{code:SQL}
and l_discount between 0.05 and 0.07
{code}
gives me right answer.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)