Opened 15 years ago

Closed 15 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: dev
Severity: Keywords: EmptyResultSet, ValuesListQuerySet
Cc: Triage Stage: Accepted
Has patch: no Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

Description

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 by Alex Gaynor, 15 years ago

Triage Stage: Unreviewed → Accepted

comment:2 by Malcolm Tredinnick, 15 years ago

Summary: EmptyResultSet exception → Queryset raising EmptyResultSet exception (instead of being empty)

Fixed title to be something descriptive.

comment:3 by Malcolm Tredinnick, 15 years ago

Resolution: → fixed
Status: new → 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