Postgres Count with OFFSET and LIMIT bug

[kane-mason]

Count is not accurate when using offset and limit.

See here for potential fix https://dba.stackexchange.com/questions/117284/count-gives-more-than-1-with-limit-1

[thomas4019]

By count, do you mean the itemsTotal field that gets returned? I feel like that should return the complete amount and if someone needs to count of just those in a specific page's response, then you can just use something like data.length. Thoughts?

[kane-mason]

Sorry for the late response. I mean count as in api.db[collection].count, if you set a limit of 1 you expect at most a count of 1 to be returned, but this is not the case.