Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
None
-
None
Description
git.commit.id.abbrev=caa8b78
Query 6:
select
sum(l_extendedprice * l_discount) as revenue
from
lineitem
where
l_shipdate >= date '1997-01-01'
and l_shipdate < date '1997-01-01' + interval '1' year
and
l_discount between 0.03 - 0.01 and 0.03 + 0.01
and l_quantity < 24
Executing this results in an empty result which does not match the expected result of "588302.8776" generated from postgres