You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@olingo.apache.org by "Patrick Haller (JIRA)" <ji...@apache.org> on 2015/04/30 13:40:06 UTC

[jira] [Created] (OLINGO-645) Multi-valued orderby query option is re-ordered in JPQL

Patrick Haller created OLINGO-645:
-------------------------------------

             Summary: 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


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)