[jira] [Created] (TRAFODION-2066) Not allowing Order By the aggregation, except when named

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

Yang Yang created TRAFODION-2066:
------------------------------------

             Summary: Not allowing Order By the aggregation, except when named
                 Key: TRAFODION-2066
                 URL: https://issues.apache.org/jira/browse/TRAFODION-2066
             Project: Apache Trafodion
          Issue Type: Bug
    Affects Versions: 2.1-incubating
         Environment: EsgynDB Advanced Release 2.1.0
JDBC Type 4, 
            Reporter: Yang Yang
            Priority: Minor


It's not allowed to Order By aggregates, unless a name is given to the aggregate. For example, 
Illegal to do "select id, groupid, sum(score)  from t group by id, groupid  order by sum(score)".   but it's legal to do "select id, groupid, sum(score) as ttlscore from t group by id, groupid, order by ttlscore". 

This may not be a problem with window functions. I've seen an example Trafodion query:
"select  username as userid,groupid,sum(allowed_size) as bandwidth, row_number()  over (partition by groupid order by SUM(allowed_size) desc) as row_number  from u_f-mv" . 

This is not a blocking bug, but for those who'd like to test drive Trafodion, the alternative of naming the aggregate may be put into SQL manual for now, before the bug is fixed. 






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