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

Odata - incorrect count with query option $count=true

    XMLWordPrintable

Details

    • Sub-task
    • Resolution: Done
    • Major
    • 9.0, 8.12.5
    • 8.12.x
    • OData
    • None

    Description

      HTTP: GET http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView?$count=true&$filter=intkey lt 5
      Header: Prefer: odata.maxpagesize=2
      Actual result: <m:count>3</m:count>
      Expected result: <m:count>4</m:count>
      Additional note: Teiid returns 2 entities.
      ----------------------------
      HTTP: GET http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView?$count=true
      Header: Prefer: odata.maxpagesize=10
      Actual result: <m:count>10</m:count>
      Expected result: <m:count>11</m:count>
      ----------------------------
      Moreover, when I invoke another request for next results (including skiptoken), Teiid returns different count.
      HTTP: GET http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView?$count=true&$skiptoken=GBRvEm+OcCFn--10
      Actual result: <m:count>1</m:count>
      Expected result: <m:count>11</m:count>
      ----------------------------
      HTTP: GET http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView?$count=true&$top=5
      Actual result: <m:count>10</m:count>
      Expected result: <m:count>11</m:count>
      Additional note: Teiid returns 5 entities.

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: