Backport of ecfea054ee2b8ddfa027459ff8b6aecba05facf7 from main

Backport of f955c90488e1f32e6e38b3c956e937579d389fb2 from main

Adjustments made to solve_lookup_type to defer the resolving of
references for summarized aggregates failed to account for similar
requirements for lookup values which can also reference annotations
through Aggregate.filter.

Regression in b181cae2.

Refs #25307.

Thanks Sergey Nesterenko for the report.

Backport of 7530cf3900ab98104edcde69e8a2a415e82b345a from main

Django 5.0+ required asgiref 3.7+, and this warning is obsolete for
asgiref 3.7+ since
https://github.com/django/asgiref/commit/be6635e0e79009e55cf7a999614186f061f9f09b.
Backport of 594873befbbec13a2d9a048a361757dd3cf178da from main

Backport of 6daf86058bb6fb922eb3fe3abae6f5c0e645020c from main

`id_for_label` is blank for widgets with multiple inputs such as radios
and multiple checkboxes. Therefore , `help_text` for fields using these
widgets cannot currently be associated using `aria-describedby`.
`id_for_label` is being used as a guard to avoid incorrectly adding
`aria-describedby` to those widgets.

This change uses `auto_id` as the unique identified for the fields
`help_text`. A guard is added to avoid incorrectly adding
`aria-describedby` to inputs by checking the widget's `use_fieldset`
attribute. Fields rendered in a `<fieldset>` should have
`aria-describedby` added to the `<fieldset>` and not every `<input>`.

Backport of 292f1ea90f90ff140617299a25884c8fda24aa64 from main

Backport of 61c305f298da1b4079a80721c861d0663dc8717e from main

Backport of 36ed45d27cb97fe3a41eca219ba75ff69f16b93c from main

Backport of 640283711e6c8d25ad0e3c97453cd178a3e4d6a6 from main

Backport of c705625ebff0141ed2b95dd3c8174bda8270a47f from main

Regression in f333e351.

Backport of 5875f03ce61b85dfd9ad34f7b871c231c358d432 from main

[5.0.x] Reverted "Refs #30446, Refs #34944 -- Fixed crash when adding GeneratedField with string Value()."

This reverts commit 8b1acc0440418ac8f45ba48e2dfcf5126c83341b.

Backport of de4884b114534f43c49cf8c5b7f10181e737f4e9 from main

Backport of 1b56b24f81a2e64b4bd3059abad9b6fd0c801c66 from main

Co-authored-by: David Sanders <shang.xiao.sanders@gmail.com>
Co-authored-by: Natalia <124304+nessita@users.noreply.github.com>

Backport of f7389c4b07ceeb036436e065898e411b247bca78 from main

Backport of 427f0ed98d7ecf4381cebd4f7773f761e2446851 from main

This should allow smarter output_field inferring in functions dealing
with text expressions.

Regression in f333e351.

Backport of 8b1acc0440418ac8f45ba48e2dfcf5126c83341b from main

Regression in 7414704e.
Backport of 8a28e983df091d94eaba77cb82fbe3ef60a80799 from main

This is a long standing bug in bc91f27a
that began manifesting in 7414704e.
Backport of 656192c2c96bb955a399d92f381e38fe2254fe17 from main

[5.0.x] Refs #34941 -- Skipped OperationTests.test_alter_field_change_nullable_to_decimal_database_default_not_null on Oracle.

Backport of 7a09ba0962e0eaf4ad396475b392ba3234bf60ee from main

CAST() must be wrapped in parentheses to be recognized as an expression on SQLite.

Regression in 7414704e.

Backport of 797957fb48f63760442d3d4c8985fd94f8602d5e from main

CockroachDB and Snowflake don't support it.

Backport of 208870b6122c4cbc39c3b2432e13db54c920db51 from main

Backport of 116e225266c511dfc0bfc96c8497e9c8aaa4d004 from main

Backport of 36173cf29d6ad0b0f0cd24326834dddfff2db7f3 from main

Backport of 7caf2621833a45cdfe7e6e305e4885ecc8d79744 from main

Thanks MProgrammer (https://hackerone.com/mprogrammer) for the report.

Backport of 9b18af4f6f12b9d25157e0b5afc3dca198f6dd06 from main

Backport of b412e5645a65a632f0147e50ceecb60acd33bb4d from main

[5.0.x] Fixed #34932 -- Restored varchar_pattern_ops/text_pattern_ops index creation when deterministic collaction is set.

Regression in f3f9d03e (4.2) and
8ed25d65 (5.0).

Backport of 34b411762b50883d768d7b67e0a158ec39da8b09 from main

Backport of 46df3ab244e1688bd186f0bfbfea6a354097a910 from main

Backport of 8992a0489c01ac8ab7283264a315c005511323e2 from main

Backport of aa80b357fbef46e5b6faa08d63bcfd4fe21f3776 from main

Backport of 8d9c0e4e244111ea3839434d8812c8573cfbf00e from main

Backport of c42250a7039a5ace1b482b30c6a1359b748cae65 from main

Also, added details about loading multiple fixtures and unified line wrapping
at 79 cols.

Co-Authored-By: Aniketh Babu <anikethbabu@gmail.com>
Co-Authored-by: Mariusz Felisiak <felisiak.mariusz@gmail.com>
Co-Authored-By: Natalia Bidart <124304+nessita@users.noreply.github.com>

Backport of 334dc073b1d9c89692aa5b11d362fb1cceae7a4a from main

Backport of 718b32c6918037cfc746d7867333d79a3c887a8c from main

[5.0.x] Fixed #27403 -- Doc'd that QuerySet.prefetch_related() doesn't guarantee transactional consistency.

Added a note about the potential race condition in prefetch_related()
that could produce an inconsistent result, one that does not correspond
to any point in the database history.

Backport of ee104251c403fbac83b8475163ff2ac01c567d25 from main

Backport of fdd1323b9c83e56184e0c992af8faf8d54327775 from main

Regression in b7fe36ad.

Thanks James Gillard for the report.

Backport of 311718feb5f1fb9ff794bbac0cda48cfc3410de8 from main