In order to lookup a Project or Namespace by path, we prefer an exact
match (case-sensitive) but in absence of that, we'd also take a
case-insensitive match.

The case-insensitive matching with preference for the exact match is a
bit more involved in SQL as the exact lookup. Yet, the majority of cases
will be an exact match. The thinking here is that we can optimize the
lookup by performing an exact match first and only if there is no
result, we perform the case-insensitive lookup.

Data for GitLab.com:
* We have about 15M records in routes table
* About 2,500 routes exist where there's more than one record
  with the same `lower(path)`

It is possible for a user to craft requests that would always trigger
the 2-step search (e.g. we have a route for `/foo/bar`, the request is
always for `/FOO/bar`). In this case, the change at hand is not
beneficial as it would run an additional query.

However, based on the data, it is highly likely that the vast majority
of requests can be satisfied with an exact match only.

The context for this change is
https://gitlab.com/gitlab-org/gitlab-ce/issues/64590#note_208156463.

Fixed grammar and inconsistencies with capitalization

See merge request gitlab-org/gitlab-ce!32337

Default clusters namespace_per_environment to true

See merge request gitlab-org/gitlab-ce!32139

Fix "Find Files Links Not URL Encoded"

Closes #62055

See merge request gitlab-org/gitlab-ce!31311

Fixes https://gitlab.com/gitlab-org/gitlab-ce/issues/62055

Add `be_http_url` matcher

Closes #65742

See merge request gitlab-org/gitlab-ce!32054

This allows the be_url matcher to be more specific. By default, it only
matches HTTP and HTTPS URIs.

Add caution that this feature requires 2 IP's

See merge request gitlab-org/gitlab-ce!31962

Apply suggestion to doc/user/project/pages/custom_domains_ssl_tls_certification/lets_encrypt_integration.md

docs: add docker-in-docker from registry example

See merge request gitlab-org/gitlab-ce!31101

Docs: Add raw endpoints limit for GL.com settings

See merge request gitlab-org/gitlab-ce!32288

Fix broken markdown in various docs

See merge request gitlab-org/gitlab-ce!32440

Fixed spelling

See merge request gitlab-org/gitlab-ce!32434

Revert "Merge branch 'nik-api-snippets-fix' into 'master'"

Closes #66673

See merge request gitlab-org/gitlab-ce!32295

Fix markdown in various docs (part 2)

See merge request gitlab-org/gitlab-ce!32269

Clean up issues that may cause the docs-lint
test to fail, such as trailing whitespace, no
EOF newline, blockquotes, etc

Add second space to lines failing lint

See merge request gitlab-org/gitlab-ce!32435

Broken Link to Test Design

See merge request gitlab-org/gitlab-ce!32279

Document the AUTO_DEVOPS_BUILD_IMAGE_EXTRA_ARGS project variable

See merge request gitlab-org/gitlab-ce!32057

Backport changes from EE MR 8186

See merge request gitlab-org/gitlab-ce!31707

Fixed spelling

See merge request gitlab-org/gitlab-ce!32432

Fixed spelling

See merge request gitlab-org/gitlab-ce!32431

Make it harder to delete issuables accidentally

Closes #62387

See merge request gitlab-org/gitlab-ce!32376

Use image proxy to mitigate stealing ip addresses

Closes #2812

See merge request gitlab/gitlabhq!2926

Ensure only authorised users can create notes on merge requests and issues

See merge request gitlab/gitlabhq!3137

Filter out old system notes for epics in notes api endpoint response

See merge request gitlab/gitlabhq!3224

Add direct upload support for personal snippets

See merge request gitlab/gitlabhq!3226

Fix HTML injection for label description

See merge request gitlab/gitlabhq!3250

Fix DNS rebind vulnerability for JIRA integration

See merge request gitlab/gitlabhq!3266