Forums - Thread Details
  • State Not Answered
  • Replies 8 replies
  • Subscribers 320 subscribers
  • Views 1503 views
  • Users 0 members are here
Forum Actions
Related

Strange behavior with rest queries with multiple offsets retiring the same result

Nick Gorham

I can create a query, such as

GET /rest/v11_4/Employees HTTP/1.1

{"offset": 4, "max_num": 1}

GET /rest/v11_4/Employees HTTP/1.1

{"offset": 5, "max_num": 1}

and up to

GET /rest/v11_4/Employees HTTP/1.1

{"offset": 17, "max_num": 1}

They return the same data each time, same id, same everything. It was first seen where  the last record of a batch of 20 was the same as the first one of the next 20, but the above with num_row=1 shows its clearly.

Oddly, If i add a field_list to the query, I don;t see the problem, and I get the expected results with each id only appearing once.

Parents Reply
  • 0 in reply to Oli Nepomiachty

    It doesn't show the problem. I suspect its the result of inserts and deletes against that API that we have done, but if we do it, I assume others could. Its happening against a cloud account, so I don;t know if you can access the DB behind that to replicate the issue (or if we can export it such that we or you can see whats going on under the hood). We only noticed the problem by chance, as we were getting a single repeated id with the default of 20, but setting it to 1 shows the problem as above.

Children