[jira] [Created] (OLINGO-1528) Olingo JPA fails on orderby and filter of expanded table

[Saurav Sahu (Jira)]

Saurav Sahu created OLINGO-1528:
-----------------------------------

             Summary: Olingo JPA fails on orderby and filter of expanded table
                 Key: OLINGO-1528
                 URL: https://issues.apache.org/jira/browse/OLINGO-1528
             Project: Olingo
          Issue Type: Bug
          Components: odata2-jpa
    Affects Versions: V2 2.0.10
            Reporter: Saurav Sahu


Olingo JPA fails for the following query -

$orderby=FreightOrder_Informations/CreationDateTime 
asc&$filter=FreightOrder_Informations/CreationDateTime ge 
'2021-01-06T18:30:00.000Z'&$expand=FreightOrder_Informations

with 

SAP DBTech JDBC: [260]: invalid column name: not included in SELECT DISTINCT 
column list: INFORMATIO1_.CreationDateTime: line 1 col 4941 (at pos 4940)

 

whereas the follwoing queries are successful - 

1. Containing orderby for expanded table's attribute

$orderby=FreightOrder_Informations/CreationDateTime 
asc&$expand=FreightOrder_Informations

 

2. Containing filter for expanded table's attribute

$filter=FreightOrder_Informations/CreationDateTime ge 
'2021-01-06T18:30:00.000Z'&$expand=FreightOrder_Informations



--
This message was sent by Atlassian Jira
(v8.3.4#803005)