Uploaded image for project: 'Kogito'
  1. Kogito
  2. KOGITO-5569

Data index query limit is not working

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 1.11.0.Final
    • None
    • Data Index
    • None
    • False
    • False
    • Documentation (Ref Guide, User Guide, etc.), Release Notes
    • Undefined
    • Hide

      1) Consider a data index installation with more than 100 user task instances created.

      2) Execute the following query:

       

      {
      UserTaskInstances (where: {state: {in: ["Ready", "Completed"]}}, orderBy : {started: ASC}, pagination: {offset: 0, limit: 100}) {
       id,
       started
      }
      }
      

      100 Tasks are returned.

       

      3) Now change the limit to a value higher than 100, e.g.

       

      {
      UserTaskInstances (where: {state: {in: ["Ready", "Completed"]}}, orderBy : {started: ASC}, pagination: {offset: 0, limit: 200}) {
       id,
       started
      }
      }
      

       

      4) The same set of 100 tasks are returned, however we know that the DB has more than 100 tasks.

       

      This worked well before.

      Show
      1) Consider a data index installation with more than 100 user task instances created. 2) Execute the following query:   { UserTaskInstances (where: {state: {in: [ "Ready" , "Completed" ]}}, orderBy : {started: ASC}, pagination: {offset: 0, limit: 100}) { id, started } } 100 Tasks are returned.   3) Now change the limit to a value higher than 100, e.g.   { UserTaskInstances (where: {state: {in: [ "Ready" , "Completed" ]}}, orderBy : {started: ASC}, pagination: {offset: 0, limit: 200}) { id, started } }   4) The same set of 100 tasks are returned, however we know that the DB has more than 100 tasks.   This worked well before.
    • 2021 Week 31-33 (from Aug 2)

      It looks like the data index query limit is fixed in 100, it worked well some weeks ago, so maybe there was a change on that regard.

       

      The issue is produced at least in Infinispan, in other repositories I don't know.

            cnicolai@redhat.com Cristiano Nicolai
            wmedvede@redhat.com Walter Medvedeo
            Tristan Radisson Tristan Radisson
            Tristan Radisson Tristan Radisson
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: