Opened 4 years ago

Closed 4 years ago

Last modified 4 years ago

#31584 closed Bug (fixed)

Queryset crashes when grouping by Exists() on Oracle.

Reported by: Mariusz Felisiak Owned by: Mariusz Felisiak
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 by Carlton Gibson, 4 years ago

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

comment:2 by Mariusz Felisiak, 4 years ago

Has patch: set

comment:3 by Carlton Gibson, 4 years ago

Triage Stage: AcceptedReady for checkin

comment:4 by GitHub <noreply@…>, 4 years ago

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 by Carlton Gibson <carlton.gibson@…>, 4 years ago

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 by Carlton Gibson <carlton.gibson@…>, 4 years ago

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