Piero Petri

Fix paginate count query when used with distinct

1

fix(src/database/querybuilder/database.ts): move the query within a subquery in paginate total count The main query has been mooved inside a subquery to keep its original syntax so that paginate() can always...

Paginate is not counting total results correctly when used with distinct

1

## Package version @adonisjs/core: ^5.6.2 @adonisjs/lucid: ^17.2.0 ## Node.js and npm version Node.js: v16.14.2 npm: 8.5.0 ## Issue When using both `distinct` and `paginate` inside a query, the total results...