delta/gitlab/gitlab-ce.git/doc/development/database_helpers.md, branch docs-sethgitlab-featureflags gitlab.com: gitlab-org/gitlab-ce.git Add Gitlab::Database::Subquery.self_join to delete_all with limit 2018-09-20T14:27:09+00:00 Toon Claes toon@gitlab.com 2018-09-18T15:32:21+00:00 ce830d3c60fbf445c67fb923f03678ad2333eba5 `delete_all` doesn't support limit, so you'd need to subquery that. And instead of subquerying with `where(id: query)`, it's better to use an `INNER JOIN`. This method also works with MySQL, while subquerying doesn't (without another layer of subquerying) Reference: https://stackoverflow.com/questions/17892762/mysql-this-version-of-mysql-doesnt-yet-support-limit-in-all-any-some-subqu/17892886#17892886 
`delete_all` doesn't support limit, so you'd need to subquery
that. And instead of subquerying with `where(id: query)`, it's better
to use an `INNER JOIN`. This method also works with MySQL, while
subquerying doesn't (without another layer of subquerying)

Reference:
https://stackoverflow.com/questions/17892762/mysql-this-version-of-mysql-doesnt-yet-support-limit-in-all-any-some-subqu/17892886#17892886