Opened 7 years ago

Closed 6 years ago

#10181 closed (fixed)

Queryset raising EmptyResultSet exception (instead of being empty)

Reported by: omat Owned by: nobody
Component: Database layer (models, ORM) Version: master
Severity: Keywords: EmptyResultSet, ValuesListQuerySet
Cc: Triage Stage: Accepted
Has patch: no Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: UI/UX:


EmptyResultSet exception is fired in 'in' lookups, if the lookup is against an empty ValuesListQuerySet.

>>> ids = Tag.objects.filter(id__in=[]).values_list(id, flat=True)
>>> Tag.objects.filter(id__in=ids)

ids is an empty ValuesListQuerySet, as expected. The second line raises EmptyResultSet exception, where I would expect an empty QuerySet instead.

Change History (3)

comment:1 Changed 7 years ago by Alex

  • Needs documentation unset
  • Needs tests unset
  • Patch needs improvement unset
  • Triage Stage changed from Unreviewed to Accepted

comment:2 Changed 6 years ago by mtredinnick

  • Summary changed from EmptyResultSet exception to Queryset raising EmptyResultSet exception (instead of being empty)

Fixed title to be something descriptive.

comment:3 Changed 6 years ago by mtredinnick

  • Resolution set to fixed
  • Status changed from new to closed

(In [9951]) Fixed #10181 -- Handle an EmptyResultSet exception case properly in nested querysets.

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