drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Khurram Faraaz (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-3595) Wrong results returned by query that uses LEAD window function
Date Mon, 03 Aug 2015 22:25:05 GMT
Khurram Faraaz created DRILL-3595:
-------------------------------------

             Summary: Wrong results returned by query that uses LEAD window function
                 Key: DRILL-3595
                 URL: https://issues.apache.org/jira/browse/DRILL-3595
             Project: Apache Drill
          Issue Type: Bug
          Components: Execution - Codegen, Execution - Flow
    Affects Versions: 1.2.0
         Environment: private-branch-new-window-funcs
            Reporter: Khurram Faraaz
            Assignee: Chris Westin


Query that uses LEAD window function returns wrong results on developer's private branch (new-window-funcs).

Results returned by Drill

{code}
0: jdbc:drill:schema=dfs.tmp> select lead(c1) over w from union_01 window w as (partition
by c3 order by c1) limit 10;
+---------+
| EXPR$0  |
+---------+
| 878     |
| -150    |
| 402     |
| 402     |
| 402     |
| 402     |
| 402     |
| 160     |
| 160     |
| 160     |
+---------+
10 rows selected (0.349 seconds)
{code}

Results returned by Postgres

{code}
postgres=# select lead(c1) over w from union_01 window w as (partition by c3 order by c1)
limit 10;
 lead 
------
     
     
  402
  402
  402
  402
  402
     
  160
  160
(10 rows)
{code}



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

Mime
View raw message