[jira] [Commented] (TRAFODION-2270) support ORDER BY clause in GROUP_CONCAT function

["ASF GitHub Bot (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/TRAFODION-2270?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15645972#comment-15645972 ] 

ASF GitHub Bot commented on TRAFODION-2270:
-------------------------------------------

Github user traflm commented on a diff in the pull request:

    https://github.com/apache/incubator-trafodion/pull/795#discussion_r86901737
  
    --- Diff: core/sql/optimizer/OptPhysRelExpr.cpp ---
    @@ -11814,10 +11814,22 @@ void SortGroupBy::addArrangementAndOrderRequirements(
       {
         // Shouldn't/Can't add a sort order type requirement
    --- End diff --
    
    I can make that change Selva. 


> support ORDER BY clause in GROUP_CONCAT function
> ------------------------------------------------
>
>                 Key: TRAFODION-2270
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-2270
>             Project: Apache Trafodion
>          Issue Type: Sub-task
>            Reporter: liu ming
>            Assignee: liu ming
>
> currently, GROUP_CONCAT() in Trafodion cannot recognize order by clause, need to support it.
> for example:
> SELECT student_name,
>           GROUP_CONCAT(DISTINCT test_score
>                     ORDER BY test_score asc SEPARATOR ' ')
>           FROM student
>           GROUP BY student_name;   
> 		  



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