"by id" Cayenne resolver fetches entire table in the absence of pagination

agrestio / agrest

Server-side Java REST Framework for easy access to data graphs from various backends

https://agrest.io

Apache License 2.0

82 stars 34 forks source link

"by id" Cayenne resolver fetches entire table in the absence of pagination #510

Closed andrus closed 2 years ago

andrus commented 2 years ago

Per #447 CayenneResolvers.nested(..).viaQueryWithParentIds() optimizes the query for pagination. However a case with no pagination now fetches the entire table, applying no qualifier. This still produces the correct result, just in a very suboptimal way. We need to correctly handle both pagination and no-pagination queries