Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-4032 Olingo V4
  3. TEIID-4061

OData - request is not traslated to valid SQL

XMLWordPrintable

    • Icon: Sub-task Sub-task
    • Resolution: Done
    • Icon: Major Major
    • 9.0, 8.12.5
    • None
    • OData
    • None

      URL: http://localhost:8080/odata4/olingo_basic/Source/Customers/?$filter=Orders_FK0/$count%20lt%202
      Result: TEIID31118 Element "g30.customerid" is not defined by any relevant group.
      SQL:

      SELECT g30.idcust, g30.name FROM Source.Customers AS g30 WHERE (SELECT COUNT(*) FROM Source.Orders AS g31 WHERE g30.customerid = g31.idcust) < ? ORDER BY g30.idcust

      Correct SQL:

      SELECT g30.idcust, g30.name FROM Source.Customers AS g30 WHERE (SELECT COUNT(*) FROM Source.Orders AS g31 WHERE g30.idcust = g31.customerid) < ? ORDER BY g30.idcust

              rhn-engineering-rareddy Ramesh Reddy
              jdurani Juraj Duráni (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: