[
https://issues.apache.org/jira/browse/METAMODEL-128?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14390180#comment-14390180
]
ASF GitHub Bot commented on METAMODEL-128:
------------------------------------------
Github user kaspersorensen commented on the pull request:
https://github.com/apache/metamodel/pull/13#issuecomment-88384811
I believe that where clause will only work on JDBC because it gets carried
along as one big expression. But MM unfortunately will not understand it so no
select items will be there anyway. Hmm how about then making a
getSelectItemByAlias(...) method. We could start with just items from SELECT
but could eventually expand it if subquery support increases.
> Ordering on aggregation value not working
> -----------------------------------------
>
> Key: METAMODEL-128
> URL: https://issues.apache.org/jira/browse/METAMODEL-128
> Project: Apache MetaModel
> Issue Type: Bug
> Affects Versions: 4.3.2
> Reporter: Ashish Mukherjee
>
> I am using a CSV Data Context example with multiple fields - occurrences,
> first_name, last_name.
> The query -
> SELECT SUM(persons.csv.occurrences) AS X, persons.csv.first_name FROM
> ashish.persons.csv GROUP BY persons.csv.first_name ORDER BY X
> This query always orders the results by first_name and not the aggregation
> value.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
