[
https://issues.apache.org/jira/browse/DRILL-3094?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Abhishek Girish closed DRILL-3094.
----------------------------------
> TPCH query 15 returns non-deterministic result
> ----------------------------------------------
>
> Key: DRILL-3094
> URL: https://issues.apache.org/jira/browse/DRILL-3094
> Project: Apache Drill
> Issue Type: Bug
> Components: Query Planning & Optimization
> Affects Versions: 1.0.0
> Reporter: Abhishek Girish
> Assignee: Aman Sinha
> Fix For: 1.1.0
>
>
> Query 15:
> {code:sql}
> create or replace view revenue0 (supplier_no, total_revenue) as
> select
> l_suppkey,
> sum(l_extendedprice * (1 - l_discount))
> from
> lineitem
> where
> l_shipdate >= date '1993-05-01'
> and l_shipdate < date '1993-05-01' + interval '3' month
> group by
> l_suppkey;
> select
> s.s_suppkey,
> s.s_name,
> s.s_address,
> s.s_phone,
> r.total_revenue
> from
> supplier s,
> revenue0 r
> where
> s.s_suppkey = r.supplier_no
> and r.total_revenue = (
> select
> max(total_revenue)
> from
> revenue0
> )
> order by
> s.s_suppkey;
> {code}
> Drill sometimes returns 0 rows and other times 1 row. Postgres always returns
> 1 row.
> This is possibly due to the non-deterministic comparison of floating point
> values.
> {code}total_revenue (calculated as sum(l_extendedprice * (1 -
> l_discount))){code} is compared with {code}max(total_revenue){code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
