summaryrefslogtreecommitdiff
path: root/docs/topics
diff options
context:
space:
mode:
authorKasyap Pentamaraju <vpentamaraju@webmd.net>2025-10-25 19:23:40 +0530
committerJacob Walls <jacobtylerwalls@gmail.com>2025-11-13 11:18:02 -0500
commit7e765a68598b2b798e49bf1f4b431a7bcac085a4 (patch)
tree1faf900bab903553ce0148a8b0df2338420745d8 /docs/topics
parent3aba1fced8254435b947467739721ec6b4fb865c (diff)
Fixed #36686 -- Clarified Meta.ordering is ignored in GROUP BY queries.
Diffstat (limited to 'docs/topics')
-rw-r--r--docs/topics/db/aggregation.txt11
1 files changed, 9 insertions, 2 deletions
diff --git a/docs/topics/db/aggregation.txt b/docs/topics/db/aggregation.txt
index 5383ba5687..ba797c0b68 100644
--- a/docs/topics/db/aggregation.txt
+++ b/docs/topics/db/aggregation.txt
@@ -627,8 +627,15 @@ fields you also select in a ``values()`` call.
You might reasonably ask why Django doesn't remove the extraneous columns
for you. The main reason is consistency with ``distinct()`` and other
places: Django **never** removes ordering constraints that you have
- specified (and we can't change those other methods' behavior, as that
- would violate our :doc:`/misc/api-stability` policy).
+ specified *explicitly with* ``order_by()`` (and we can't change those
+ other methods' behavior, as that would violate our
+ :doc:`/misc/api-stability` policy).
+
+.. admonition:: Default ordering not applied to GROUP BY
+
+ ``GROUP BY`` queries (for example, those using ``.values()`` and
+ ``.annotate()``) don't use the model's default ordering.
+ Use ``order_by()`` explicitly when a given order is needed.
Aggregating annotations
-----------------------