[jira] [Created] (DRILL-3360) Window function defined within another window function

["Khurram Faraaz (JIRA)" <ji...@apache.org>]

Khurram Faraaz created DRILL-3360:
-------------------------------------

             Summary: Window function defined within another window function 
                 Key: DRILL-3360
                 URL: https://issues.apache.org/jira/browse/DRILL-3360
             Project: Apache Drill
          Issue Type: Bug
          Components: Query Planning & Optimization
    Affects Versions: 1.1.0
         Environment: CentOS 4 node cluster
            Reporter: Khurram Faraaz
            Assignee: Jinfeng Ni


Window function defined within another window function, Postgres 9.3 does not support this, Drill supports it and we see results being returned. We should not support this kind of query.

>From Postgres 9.3
{code}
postgres=# select rank() over(order by row_number() over(order by col_int)) from vwOnParq_wCst;
ERROR:  window functions are not allowed in window definitions
LINE 1: select rank() over(order by row_number() over(order by col_i...
{code}

>From execution on Drill
{code}
0: jdbc:drill:schema=dfs.tmp> select rank() over(order by row_number() over(order by col_int)) from vwOnParq_wCst;
+---------+
| EXPR$0  |
+---------+
| 1       |
| 2       |
| 3       |
| 4       |
| 5       |
| 6       |
| 7       |
| 8       |
| 9       |
| 10      |
| 11      |
| 12      |
| 13      |
| 14      |
| 15      |
| 16      |
| 17      |
| 18      |
| 19      |
| 20      |
| 21      |
| 22      |
| 23      |
| 24      |
| 25      |
| 26      |
| 27      |
| 28      |
| 29      |
| 30      |
+---------+
30 rows selected (0.377 seconds)
{code}



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