CountOptions are not included in PaginateOptions

[pbatr]

We are running into the problem that totalCount is wrong when using paginate with inner joins (most likely only with many-to-many relations but did not dig deeper). A workaround is to pass distinct: true parameter to .paginate() because since 401972b the query args are passed also to .count() and that fixes the issue. But now typescript is complaining because .paginate() only takes FindOptions and that type does not include distinct.

I would suggest to either update the type to include also CountOptions or include distinct: true in totalCountQueryOptions and cursorCountQueryOptions.

[duncanhoggan]

I'm also having this issue, would be a great addition

[Kaltsoon]

Did I understand correctly, that including dinstinct?: boolean to PaginateOptions type and passing the distinct to the count query would work in this case?

export interface PaginateOptions<ModelType extends Model>
  extends FindOptions<Attributes<ModelType>> {
  after?: string;
  before?: string;
  distinct?: boolean; 
}

This sounds like an escape hatch for the problem. Would be nice to find and solve the root problem.