We allow `add_column` and `create_table` methods inside the `down`
method in post-deploy migrations. But if these methods were wrapped
inside a statement like `if` then the cop was raising an error.
For example, in the following, the 2nd example was being incorrectly
flagged as an offense:

```
def down
  add_column(:table, :column)
end
```

```
def down
  add_column(:table, :column) unless column_exists(:table, :column)
end
```

Improve test suite performance

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/121854



Merged-by: John Mason <9717668-john-mason@users.noreply.gitlab.com>
Approved-by: Jay McCure <jmccure@gitlab.com>
Approved-by: John Mason <9717668-john-mason@users.noreply.gitlab.com>
Co-authored-by: Vasilii Iakliushin <viakliushin@gitlab.com>

Remove yarn-audit Dependency Scanning

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/122372



Merged-by: David Dieulivol <ddieulivol@gitlab.com>
Approved-by: Philippe Lafoucrière <30915-plafoucriere@users.noreply.gitlab.com>
Approved-by: David Dieulivol <ddieulivol@gitlab.com>
Co-authored-by: Olivier Gonzalez <52092-gonzoyumo@users.noreply.gitlab.com>

Merge branch 'bdenkovych-gitlab-admin-should-bypass-group-sso-enforcement-issue-413568' into 'master'

GitLab Admins should bypass Group SSO enforcement

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/122169



Merged-by: Mikołaj Wawrzyniak <mwawrzyniak@gitlab.com>
Approved-by: Drew Blessing <drew@gitlab.com>
Approved-by: Kevin Morrison <kmorrison@gitlab.com>
Co-authored-by: Bogdan Denkovych <bdenkovych@gitlab.com>

Tidy up codeowners E2E use Commit over ProjectPush

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/122392



Merged-by: Andrejs Cunskis <acunskis@gitlab.com>
Approved-by: Harsha Muralidhar <hmuralidhar@gitlab.com>
Approved-by: Andrejs Cunskis <acunskis@gitlab.com>
Co-authored-by: John McDonnell <jmcdonnell@gitlab.com>

[Audit Events] Provide all audit events under a group via the API

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/115898



Merged-by: Adam Hegyi <ahegyi@gitlab.com>
Approved-by: Adam Hegyi <ahegyi@gitlab.com>
Approved-by: Aaron Huntsman <ahuntsman@gitlab.com>
Reviewed-by: Jarka Košanová <jarka@gitlab.com>
Reviewed-by: Evan Read <eread@gitlab.com>
Reviewed-by: Sincheol (David) Kim <dkim@gitlab.com>
Co-authored-by: Michael Becker <11881043-wandering_person@users.noreply.gitlab.com>
Co-authored-by: Evan Read <eread@gitlab.com>

Background Context
------------------------

We want to be able to return all audit events under a given groups via
a single endpoint. We have an issue, [_API endpoint to retrieve all
audit events under a given group_][0], to track this feature.

We actually had already implemented that feature, but the performance
was so poor in production that it functionally did not work. The
database query timed out almost 100% of the time.

The proposal was to improve the existing query's performance by using
the [`InOperatorOptimization`][1] library.

Attempts to do this did not show a good performance boost (details
[here][2])

Another Approach
----------------

We then thought about implementing this feature with a new
approach. The Idea is that we can add a new column, `group_rollup`, to
the `audit_events` table. This column will be the `id` of the
top-level group the audit event belongs to.

We could then update the Auditor to write this value at audit event
creation, allowing us to implement the endpoint with a simple query:

```sql
SELECT *
FROM "audit_events"
WHERE "audit_events"."group_rollup_id" == @group.id
```

This query performed much better in database lab (details in this
[spike issue][3])

Back to InOperatorOptimization
---------------------------------
In the MR for the `group_rollup_id` approach, it was discovered that
with some tweaking and adding a new index, the InOperatorOptimization
might just work

So this commit adds the application code for that approach.

The index additions are tracked in these issues:

- [asynchronous database index addition][4]
- [synchronous database index addition][5]

[0]:https://gitlab.com/gitlab-org/gitlab/-/issues/337757
[1]:https://docs.gitlab.com/ee/development/database/efficient_in_operator_queries.html
[2]:https://gitlab.com/gitlab-org/gitlab/-/issues/337757#note_1312002908
[3]:https://gitlab.com/gitlab-org/gitlab/-/issues/396778#note_1325762680
[4]:https://gitlab.com/gitlab-org/gitlab/-/issues/411167
[5]:https://gitlab.com/gitlab-org/gitlab/-/issues/411129

Changelog: changed
EE: true

Update file details for project access token limits in Trials

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/122486



Merged-by: Jon Glassman <jglassman@gitlab.com>
Approved-by: Andrew Kelly <akelly@gitlab.com>
Approved-by: Jon Glassman <jglassman@gitlab.com>
Co-authored-by: Tim Poffenbarger <tpoffenbarger@gitlab.com>

Add single-redis jobs to coverage dependency

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/122421



Merged-by: David Dieulivol <ddieulivol@gitlab.com>
Approved-by: David Dieulivol <ddieulivol@gitlab.com>
Approved-by: Michael Becker <11881043-wandering_person@users.noreply.gitlab.com>
Reviewed-by: Michael Becker <11881043-wandering_person@users.noreply.gitlab.com>
Co-authored-by: Sylvester Chin <schin@gitlab.com>

Add Background Migration to Backfill Root Storage Statistics Fork Sizes

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/120916



Merged-by: Suraj Tripathi <stripathi@gitlab.com>
Approved-by: Suraj Tripathi <stripathi@gitlab.com>
Reviewed-by: Krasimir Angelov <kangelov@gitlab.com>
Reviewed-by: Vijay Hawoldar <vhawoldar@gitlab.com>
Co-authored-by: Jason Goodman <jgoodman@gitlab.com>

Backfill the following columns for namespace_root_storage_statistics:
 - public_forks_storage_size
 - internal_forks_storage_size
 - private_forks_storage_size

Changelog: added

Merge branch '397074-add-the-correct-tags-to-the-issue-created-by-the-schema-validation-framework' into 'master'

Add the correct tags to the schema validation issue

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/115881



Merged-by: Dylan Griffith <dyl.griffith@gmail.com>
Approved-by: Gregory Havenga <11164960-ghavenga@users.noreply.gitlab.com>
Approved-by: Leonardo da Rosa <ldarosa@gitlab.com>
Approved-by: Dylan Griffith <dyl.griffith@gmail.com>
Reviewed-by: Alex Ives <aives@gitlab.com>
Reviewed-by: Leonardo da Rosa <ldarosa@gitlab.com>
Co-authored-by: dfrazao-gitlab <dfrazao@gitlab.com>

- When a new inconsistency is found, the system will fetch
  the feature categories from the table dictionary and add
  them as labels for the inconsistency issue.

Changelog: added
Relates to: https://gitlab.com/gitlab-org/gitlab/-/merge_requests/115881

Docs artifacts public warning

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/122334



Merged-by: Fiona Neill <fneill@gitlab.com>
Approved-by: Jocelyn Eillis <jeillis@gitlab.com>
Co-authored-by: Marcel Amirault <mamirault@gitlab.com>

Update dependency kas to v16.1.2

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/122594



Merged-by: Shinya Maeda <shinya@gitlab.com>
Approved-by: Shinya Maeda <shinya@gitlab.com>
Co-authored-by: GitLab Renovate Bot <gitlab-bot@gitlab.com>

Quarantine stale test

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/122589



Merged-by: Andrejs Cunskis <acunskis@gitlab.com>
Approved-by: Jay McCure <jmccure@gitlab.com>
Approved-by: Andrejs Cunskis <acunskis@gitlab.com>
Co-authored-by: Mark Lapierre <mlapierre@gitlab.com>

Remove direct data manipulation from job_item_spec

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/122536



Merged-by: Ezekiel Kigbo <3397881-ekigbo@users.noreply.gitlab.com>
Approved-by: Deepika Guliani <dguliani@gitlab.com>
Approved-by: Ezekiel Kigbo <3397881-ekigbo@users.noreply.gitlab.com>
Co-authored-by: Artur Fedorov <afedorov@gitlab.com>

Update VS Code extensions for GitPod

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/122546



Merged-by: Kushal Pandya <kushal@gitlab.com>
Approved-by: Kushal Pandya <kushal@gitlab.com>
Co-authored-by: Anatoli Babenia <anatoli@rainforce.org>

There are no security issues with it to keep it pinned.

Update Jira DVCS documentation

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/122459



Merged-by: Ashraf Khamis <akhamis@gitlab.com>
Approved-by: Ashraf Khamis <akhamis@gitlab.com>
Co-authored-by: Andy Soiron <asoiron@gitlab.com>

Remove dismiss button for storage alerts that require user attention

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/122494



Merged-by: Dylan Griffith <dyl.griffith@gmail.com>
Approved-by: Dylan Griffith <dyl.griffith@gmail.com>
Approved-by: Mohamed Hamda <mhamda@gitlab.com>
Reviewed-by: Mohamed Hamda <mhamda@gitlab.com>
Co-authored-by: Sheldon Led <sheldonled@gitlab.com>

Add variable type to variable factories

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/121125



Merged-by: Erick Bajao <fbajao@gitlab.com>
Approved-by: Erick Bajao <fbajao@gitlab.com>
Co-authored-by: Albert Salim <asalim@gitlab.com>

Audit event for merge request merged deletion started

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/121594



Merged-by: Jessie Young <jessieyoung@gitlab.com>
Approved-by: Hitesh Raghuvanshi <hraghuvanshi@gitlab.com>
Approved-by: Jessie Young <jessieyoung@gitlab.com>
Reviewed-by: Hitesh Raghuvanshi <hraghuvanshi@gitlab.com>
Reviewed-by: Jessie Young <jessieyoung@gitlab.com>
Co-authored-by: Hitesh Raghuvanshi <hraghuvanshi@gitlab.com>
Co-authored-by: harsimarsandhu <hsandhu@gitlab.com>

This commit adds audit event when a merged merge request
deletion is started.

EE: true
Changelog: added

Update Troubleshooting common issues configuring security policies

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/122285



Merged-by: Russell Dickenson <rdickenson@gitlab.com>
Approved-by: Alan (Maciej) Paruszewski <mparuszewski@gitlab.com>
Approved-by: Grant Hickman <ghickman@gitlab.com>
Approved-by: Russell Dickenson <rdickenson@gitlab.com>
Co-authored-by: Falko Sieverding <fsieverding@gitlab.com>

Add path attribute to organizations

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/122050



Merged-by: Tiger Watson <twatson@gitlab.com>
Approved-by: Rutger Wessels <rwessels@gitlab.com>
Approved-by: Tiger Watson <twatson@gitlab.com>
Approved-by: Mohamed Hamda <mhamda@gitlab.com>
Reviewed-by: Tiger Watson <twatson@gitlab.com>
Reviewed-by: Manoj M J <mmj@gitlab.com>
Reviewed-by: Mohamed Hamda <mhamda@gitlab.com>
Reviewed-by: Rutger Wessels <rwessels@gitlab.com>
Co-authored-by: Manoj M J <mmj@gitlab.com>

Add path attribute to organizations

Changelog: other

Fix alignment of chevron icon

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/122530



Merged-by: Ezekiel Kigbo <3397881-ekigbo@users.noreply.gitlab.com>
Approved-by: Ezekiel Kigbo <3397881-ekigbo@users.noreply.gitlab.com>
Approved-by: Amelia Bauerly <abauerly@gitlab.com>
Co-authored-by: Annabel Dunstone Gray <annabel.dunstone@gmail.com>

Document non-Vale/markdownlint tests in lint-doc.sh

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/122359



Merged-by: Evan Read <eread@gitlab.com>
Approved-by: Marcel Amirault <mamirault@gitlab.com>
Reviewed-by: Marcel Amirault <mamirault@gitlab.com>
Co-authored-by: Marcel Amirault <mamirault@gitlab.com>
Co-authored-by: Amy Qualls <aqualls@gitlab.com>

The docs-lint markdown job is sneaky, and runs an additional check
that we don't talk much about.

Update code suggestions experimental IDE support

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/122580



Merged-by: Wayne Haber <whaber@gitlab.com>