Opened 4 months ago

Closed 4 months ago

Last modified 4 months ago

#31584 closed Bug (fixed)

Queryset crashes when grouping by Exists() on Oracle.

Reported by: felixxm Owned by: felixxm
Component: Database layer (models, ORM) Version: 3.0
Severity: Release blocker Keywords: oracle exists boolean
Cc: Triage Stage: Ready for checkin
Has patch: yes Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

Description

Boolean expressions are not supported in the GROUP_BY clause on Oracle. Noticed when polishing PR.

Regression in efa1908f662c19038a944129c81462485c4a9fe8.

Change History (6)

comment:1 Changed 4 months ago by Carlton Gibson

Summary: Queryset crashes when gruping by Exists() on Oracle.Queryset crashes when grouping by Exists() on Oracle.
Triage Stage: UnreviewedAccepted

comment:2 Changed 4 months ago by felixxm

Has patch: set

comment:3 Changed 4 months ago by Carlton Gibson

Triage Stage: AcceptedReady for checkin

comment:4 Changed 4 months ago by GitHub <noreply@…>

Resolution: fixed
Status: assignedclosed

In 3a94123:

Fixed #31584 -- Fixed crash when chaining values()/values_list() after Exists() annotation and aggregation on Oracle.

Oracle requires the EXISTS expression to be wrapped in a CASE WHEN in
the GROUP BY clause.

Regression in efa1908f662c19038a944129c81462485c4a9fe8.

comment:5 Changed 4 months ago by Carlton Gibson <carlton.gibson@…>

In b46b0f8:

[3.1.x] Fixed #31584 -- Fixed crash when chaining values()/values_list() after Exists() annotation and aggregation on Oracle.

Oracle requires the EXISTS expression to be wrapped in a CASE WHEN in
the GROUP BY clause.

Regression in efa1908f662c19038a944129c81462485c4a9fe8.
Backport of 3a941230c85b2702a5e1cd97e17251ce21057efa from master

comment:6 Changed 4 months ago by Carlton Gibson <carlton.gibson@…>

In 92acf102:

[3.0.x] Fixed #31584 -- Fixed crash when chaining values()/values_list() after Exists() annotation and aggregation on Oracle.

Oracle requires the EXISTS expression to be wrapped in a CASE WHEN in
the GROUP BY clause.

Regression in efa1908f662c19038a944129c81462485c4a9fe8.
Backport of 3a941230c85b2702a5e1cd97e17251ce21057efa from master

Note: See TracTickets for help on using tickets.
Back to Top