[Django] #28904: Queryset exclude not working properly

[Django]

#28904: Queryset exclude not working properly
-------------------------------------+-------------------------------------
Reporter: Prasad | Owner: nobody
Sidda |
Type: Bug | Status: new
Component: | Version: 1.8
Uncategorized | Keywords: __in=[None],in with
Severity: Normal | None
Triage Stage: | Has patch: 0
Unreviewed |
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
Excluding query with **in** condtion by providing **[None]** as list.

Please find attachment below

--
Ticket URL: <https://code.djangoproject.com/ticket/28904>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

[Django]

#28904: Queryset exclude not working properly
-------------------------------------+-------------------------------------

Reporter: Prasad Sidda | Owner: nobody
Type: Bug | Status: new
Component: Uncategorized | Version: 1.8
Severity: Normal | Resolution:
Keywords: __in=[None],in with | Triage Stage:
None | Unreviewed
Has patch: 0 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Prasad Sidda):

* Attachment "Screen Shot 2017-12-06 at 4.17.12 PM.png" added.

[Django]

#28904: Queryset exclude not working properly
-------------------------------------+-------------------------------------

Reporter: Prasad Sidda | Owner: nobody

Type: Bug | Status: closed
Component: Uncategorized | Version: 1.8
Severity: Normal | Resolution: invalid

Keywords: __in=[None],in with | Triage Stage:
None | Unreviewed

Has patch: 0 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Jani Tiainen):

* status: new => closed
* resolution: => invalid

Comment:

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.

--
Ticket URL: <https://code.djangoproject.com/ticket/28904#comment:1>

[Django]

#28904: QuerySet.exclude() doesn't work properly with __in and a list containing
None

-------------------------------------+-------------------------------------
Reporter: Prasad Sidda | Owner: nobody
Type: Bug | Status: closed

Component: Database layer | Version: 1.8
(models, ORM) |
Severity: Normal | Resolution: duplicate

Keywords: __in=[None],in with | Triage Stage:
None | Unreviewed

Has patch: 0 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Tim Graham):

* resolution: invalid => duplicate
* component: Uncategorized => Database layer (models, ORM)

Old description:

> Excluding query with **in** condtion by providing **[None]** as list.
>
> Please find attachment below

New description:

Excluding query with `__in` condition by providing `[None]`` as list.

Please find attachment below.

--

Comment:

Duplicate of #20024.

--
Ticket URL: <https://code.djangoproject.com/ticket/28904#comment:2>