drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Victoria Markman (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (DRILL-3327) row_number function returns incorrect result when only order by clause is specified
Date Thu, 25 Jun 2015 17:31:05 GMT

     [ https://issues.apache.org/jira/browse/DRILL-3327?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Victoria Markman resolved DRILL-3327.
-------------------------------------
    Resolution: Fixed

> row_number function returns incorrect result when only order by clause is specified
> -----------------------------------------------------------------------------------
>
>                 Key: DRILL-3327
>                 URL: https://issues.apache.org/jira/browse/DRILL-3327
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Query Planning & Optimization
>    Affects Versions: 1.0.0
>            Reporter: Victoria Markman
>            Assignee: Victoria Markman
>            Priority: Critical
>              Labels: window_function
>             Fix For: 1.1.0
>
>         Attachments: 0001-DRILL-3327-If-no-partition-by-is-specified-read-all-.patch,
j1.tar, row_number_wrong_result.tar
>
>
> Queries returning wrong result:
> {code}
> select c_integer, row_number() over(order by c_integer) from j1 order by 2;
> select c_integer, row_number() over(order by c_integer) from j1 order by 2 desc;
> select c_integer, row_number() over(order by c_integer desc) from j1 order by 2;
> select c_integer, row_number() over(order by c_integer desc) from j1 order by 2;
> select c_integer, row_number() over(order by c_integer nulls first) from j1 order by
c_integer nulls last,  row_number() over(order by c_integer nulls first);
> select c_integer, row_number() over(order by c_integer nulls last) from j1 order by c_integer
nulls first, row_number() over(order by c_integer nulls last);
> {code}
> In attached tar file (row_number_wrong_result.tar) you will find:
> 1. *.sql - file that contains query
> 2. *.res - expected result (generated from Postgres)
> 3. *.out - result returned by drill



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

Mime
View raw message