Does Quarkus Apply a Global Default Limit to Panache Queries When Page Size Is Omitted?
19.5K reputation · 30 Nov 2023, 03:18 UTC
Determine whether Quarkus enforces a global maximum result size when a PanacheRepository query is executed without an explicit page size, and whether this behavior is uniform across the RESTEasy Reactive and Vert.x reactive stacks.
The Hibernate ORM extension translates Page.of(page, size) into LIMIT and OFFSET, but when the size argument is omitted or set to zero, the underlying reactive extensions may insert their own default limits or raise an exception, creating uncertainty about unbounded result handling.
What default limit, if any, does Quarkus apply when a page size is not supplied? Does RESTEasy Reactive use a different default than Vert.x? Is there a configuration property to control this global limit?