[Django] #28904: Queryset exclude not working properly

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

[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.

--
You received this message because you are subscribed to the Google Groups "Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To post to this group, send email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/django-updates/054.41862a3e7946f7d4a2ae88e627878b79%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
Reply | Threaded
Open this post in threaded view
|

Re: [Django] #28904: Queryset exclude not working properly

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.


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

--
You received this message because you are subscribed to the Google Groups "Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To post to this group, send email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/django-updates/069.ad203640ab4dfd917c5326102a721979%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
Reply | Threaded
Open this post in threaded view
|

Re: [Django] #28904: Queryset exclude not working properly

Django
In reply to this post by 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 <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

--
You received this message because you are subscribed to the Google Groups "Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To post to this group, send email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/django-updates/069.b04ababd4484df1e45d43714d276cc1d%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
Reply | Threaded
Open this post in threaded view
|

Re: [Django] #28904: QuerySet.exclude() doesn't work properly with __in and a list containing None (was: Queryset exclude not working properly)

Django
In reply to this post by 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>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

--
You received this message because you are subscribed to the Google Groups "Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To post to this group, send email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/django-updates/069.6235ba8ef0e4ce714d7fedfe1ad20401%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.