[
https://issues.apache.org/jira/browse/TRAFODION-2270?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15617125#comment-15617125
]
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_r85630428
--- Diff: core/sql/regress/executor/TEST002 ---
@@ -1102,7 +1102,7 @@ SELECT student_name,
SELECT student_name,
GROUP_CONCAT(DISTINCT test_score
- ORDER BY test_score SEPARATOR '-')
+ ORDER BY test_score desc SEPARATOR '-')
--- End diff --
Previous ORDER BY do nothing, it is ignored. So there will be regression
failure , since the order is random.
I can insert more rows into the table, above syntax is the most complex
syntax for this feature. But I can design a more complex query to use join for
example?
ORDER BY in an aggregate function is regarded as extraOrder requirement,
that is the basic idea of this change. Because function is ItemExpr, so it
cannot have its own sort requirement as I understand.
Let me first check the shortcut groupby and partial groupby issue
> 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)
