[
https://issues.apache.org/jira/browse/OLINGO-645?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Christian Amend resolved OLINGO-645.
------------------------------------
Resolution: Duplicate
Assignee: Christian Amend
Closed due to being a duplicate. Work will continue on the other issue.
> Multi-valued orderby query option is re-ordered in JPQL
> -------------------------------------------------------
>
> Key: OLINGO-645
> URL: https://issues.apache.org/jira/browse/OLINGO-645
> Project: Olingo
> Issue Type: Bug
> Components: odata2-jpa
> Affects Versions: V2 2.0.3
> Reporter: Patrick Haller
> Assignee: Christian Amend
>
> The URL
> "http://localhost:8080/olingojpa.svc/Addresss?$skip=0&$top=100&$orderby=Attr3%20asc,Attr1%20desc,Attr2%20desc&$inlinecount=allpages";
> is rendered to
> "SELECT E1 FROM Address E1 ORDER BY E1.Attr1 DESC , E1.Attr2 DESC , E1.Attr3"
> Attr1, Attr2, and Attr3 have changed their positions, effectively leading to
> an unexpected database query result.
> The expected SQL would have been
> "SELECT E1 FROM Address E1 ORDER BY E1.Attr3, E1.Attr1 DESC, E1.Attr2 DESC"
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
