fix(database): updateMany ignores _q and filters - #27769

What does it do?

updateMany now initializes the query builder with the same filter keys as deleteMany and count: _q, where, and filters. Pagination, populate, and select stay ignored so the write set does not diverge from count.

Why is it needed?

updateMany({ _q: 'Hugo', data }) updated every row (count=3 instead of 1). Entity-manager updateMany only forwarded where + data. Query-builder init({ _q, where }).update() already works after #26909. This is not a #26909 regression.

How to test it?

yarn test:unit update-many.test.ts relation-subquery.test.ts --forceExit
# in packages/core/database

yarn test:api -- --generate-app=false tests/api/core/database/db.test.api.js
# "updateMany relation filters" and "deleteMany filter params"

Related issue(s)/PR(s)

• Fixes updateMany ignores _q and filters #27768
• Related fix(database): updateMany with relation filter subquery #26909

AI assisted