FindAndCountAll generates wrong query for count

[lafriks]

When selecting total count soft-deleted record condition is not added to count select query.

From log:

time="2021-10-19T17:08:05+03:00" level=info msg=Query args="[false]" fields.time="560.007µs" pid=680 rowCount=1 sql="SELECT * FROM \"clients\" WHERE \"deleted\"=$1 LIMIT 20;"
time="2021-10-19T17:08:05+03:00" level=info msg=Query args="[]" fields.time="420.81µs" pid=680 rowCount=1 sql="SELECT count(*) AS result FROM \"clients\";"

[Fs02]

Thanks for the report, this bug happens because this line:

rel/repository.go

Line 322 in d24adc0

return r.aggregate(cw, query, "count", "*")

is not wrapping the query withDefaultScope, looks like modfying the line to be: return r.aggregate(cw, r.withDefaultScope(col.data, query, true), "count", "*") is enough to fix this

[lafriks]

That was fast, thanks :)