django.git/django/db/models/sql/where.py, branch stable/5.2.x

[5.2.x] Refs #36181 -- Removed the obsolete SubqueryConstraint machinery.

2025-02-15T16:48:53Z

Adding proper support for subquery right-hand-sides to TupleIn made it obsolete. Backport of d386405e04dac50656af50d100a14efdf8c58e8f from main Co-authored-by: Simon Charette

Applied Black's 2024 stable style.

2024-01-26T11:45:07Z

https://github.com/psf/black/releases/tag/24.1.0

Refs #35102 -- Optimized replace_expressions()/relabelling aliases by adding early return.

2024-01-15T04:56:38Z

This avoids costly hashing. Thanks Anthony Shaw for the report. Co-Authored-By: Simon Charette

Fixed #34604 -- Corrected fallback SQL for n-ary logical XOR.

2023-06-08T18:41:18Z

An n-ary logical XOR Q(…) ^ Q(…) ^ … ^ Q(…) should evaluate to true when an odd number of its operands evaluate to true, not when exactly one operand evaluates to true.

Fixed #28477 -- Stripped unused annotations on aggregation.

2022-11-09T12:22:14Z

Also avoid an unnecessary pushdown when aggregating over a query that doesn't have aggregate annotations.

Refs #33374 -- Adjusted full match condition handling.

2022-11-07T19:23:53Z

Adjusting WhereNode.as_sql() to raise an exception when encoutering a full match just like with empty matches ensures that all case are explicitly handled.

Refs #30158 -- Removed alias argument for Expression.get_group_by_cols().

2022-10-06T10:04:00Z

Recent refactors allowed GROUP BY aliasing allowed for aliasing to be entirely handled by the sql.Query.set_group_by and compiler layers.

Fixed #34024 -- Fixed crash when aggregating querysets with Q objects annotations.

2022-09-23T14:15:03Z

This reverts b64db05b9cedd96905d637a2d824cbbf428e40e7. It was reasonable to assume it was unnecessary code as there were no failing tests upon its removal. This commit adds the necessary regression tests for the failing condition identified in #34024 alongside the original tests added in the PR for which WhereNode.is_summary was introduced.

Refs #28333 -- Added partial support for filtering against window functions.

2022-08-15T06:26:26Z

Adds support for joint predicates against window annotations through subquery wrapping while maintaining errors for disjointed filter attempts. The "qualify" wording was used to refer to predicates against window annotations as it's the name of a specialized Snowflake extension to SQL that is to window functions what HAVING is to aggregates. While not complete the implementation should cover most of the common use cases for filtering against window functions without requiring the complex subquery pushdown and predicate re-aliasing machinery to deal with disjointed predicates against columns, aggregates, and window functions. A complete disjointed filtering implementation should likely be deferred until proper QUALIFY support lands or the ORM gains a proper subquery pushdown interface.

Refs #32948 -- Added Node.copy().

2022-07-27T08:06:24Z

This allows the copy.copy() usage in the Q._combine() method to finish sooner, instead of having to fallback to using the __reduce_ex__(4) method. Thia also avoids having to fall into copy.copy() at in Q._combine(), when combining a Q() with another Q(). Co-authored-by: Keryn Knight