summaryrefslogtreecommitdiff
path: root/doc/development/database_helpers.md
Commit message (Collapse)AuthorAgeFilesLines
* Add Gitlab::Database::Subquery.self_join to delete_all with limitToon Claes2018-09-201-0/+63
`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