Re: [Django] #28023: Wrong method in SQL query log

[Django]

#28023: Wrong method in SQL query log
-+-
 Reporter:  erkib|Owner:  nobody
 Type:  Bug  |   Status:  closed
Component:  Database layer   |  Version:  1.11
  (models, ORM)  |
 Severity:  Normal   |   Resolution:  invalid
 Keywords:   | Triage Stage:
 |  Unreviewed
Has patch:  0|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+-
Changes (by Simon Charette):

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


Comment:

 This is caused by a combination of two things:

 1. You have a `pre_delete`/`post_delete` signal registered for your
 `MyModel` or foreign keys pointing to it so Django doesn't perform a
 `DELETE FROM` right away and collects objects matching your `filter()` in
 memory to simulate `ON DELETE`.
 2. No `MyModel` match your filter no the collection routine stops right
 away and doesn't both performing a `DELETE FROM`.

--
Ticket URL: 
Django 
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 django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/063.e7f36e95e7a404354b857b5b00a0cc47%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #28023: Wrong method in SQL query log

[Django]

#28023: Wrong method in SQL query log
-+-
 Reporter:  erkib|Owner:  nobody
 Type:  Bug  |   Status:  new
Component:  Database layer   |  Version:  1.11
  (models, ORM)  |
 Severity:  Normal   |   Resolution:
 Keywords:   | Triage Stage:
 |  Unreviewed
Has patch:  0|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+-

Comment (by kapil garg):

 I don't see this. Here is the model i used and query i performed


 {{{
 class Test(models.Model):
 name = models.CharField(max_length=100, blank=True)

 #shell
 >>> Test.objects.filter(name__startswith='test').delete()
 (0.000) BEGIN; args=None
 (0.001) DELETE FROM "bug_test" WHERE "bug_test"."name" LIKE 'test%' ESCAPE
 '\'; args=('test%',)
 (1, {'bug.Test': 1})
 }}}

 Is this bug related to some particular backend or does this bug also
 result in failure of the `delete()` method ?
 Does your object get deleted or not ?

--
Ticket URL: 
Django 
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 django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/063.33589278b46442bc62d2db45d8f78200%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

[Django] #28023: Wrong method in SQL query log

[Django]

#28023: Wrong method in SQL query log
-+-
   Reporter:  erkib  |  Owner:  nobody
   Type:  Bug| Status:  new
  Component:  Database   |Version:  1.11
  layer (models, ORM)|
   Severity:  Normal |   Keywords:
   Triage Stage: |  Has patch:  0
  Unreviewed |
Needs documentation:  0  |Needs tests:  0
Patch needs improvement:  0  |  Easy pickings:  0
  UI/UX:  0  |
-+-
 When SQL query logging is enabled and you run a following:


 {{{
 n = now() - timedelta(days=30)
 MyModel.objects.filter(my_date__lt=n).delete()
 }}}


 Query being logged is:

 2017-04-05 11:41:22,192  DEBUG(0.019) QUERY = 'SELECT "MY_MODEL"."ID",
 "MY_MODEL"."MY_DATE" FROM "MY_MODEL" WHERE "MY_MODEL"."MY_DATE" < :arg0' -
 PARAMS = (Oracle_datetime(2017, 3, 6, 8, 41, 21, 913366),);
 args=(Oracle_datetime(2017, 3, 6, 8, 41, 21, 913366),)

 The same behaviour happens with 1.10.* version of Django as well.

--
Ticket URL: 
Django 
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 django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/048.96aa15a046354f4baf7773ec395e1589%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.