#28904 closed Bug (duplicate)
QuerySet.exclude() doesn't work properly with __in and a list containing None
| Reported by: | Prasad Sidda | Owned by: | nobody |
|---|---|---|---|
| Component: | Database layer (models, ORM) | Version: | 1.8 |
| Severity: | Normal | Keywords: | __in=[None], in with None |
| Cc: | Triage Stage: | Unreviewed | |
| Has patch: | no | Needs documentation: | no |
| Needs tests: | no | Patch needs improvement: | no |
| Easy pickings: | no | UI/UX: | no |
Description (last modified by )
Excluding query with __in condition by providing [None]` as list.
Please find attachment below.
Attachments (1)
Change History (3)
by , 7 years ago
| Attachment: | Screen Shot 2017-12-06 at 4.17.12 PM.png added |
|---|
comment:1 by , 7 years ago
| Resolution: | → invalid |
|---|---|
| Status: | new → closed |
Version 0, edited 7 years ago by (next)
comment:2 by , 7 years ago
| Component: | Uncategorized → Database layer (models, ORM) |
|---|---|
| Description: | modified (diff) |
| Resolution: | invalid → duplicate |
| Summary: | Queryset exclude not working properly → QuerySet.exclude() doesn't work properly with __in and a list containing None |
Duplicate of #20024.
Note:
See TracTickets
for help on using tickets.
This is actually how SQL works. None will be translated to NULL and NULL is compared to any value is undefined in SQL.
Closing ticket as invalid.