#16426: sqlite: Cannot delete more than 999 things if there is a relation
pointing
to them
-------------------------------------+-------------------------------------
Reporter: kmtracey | Owner: nobody
Type: Bug | Status: closed
Component: Database layer | Version: 1.3
(models, ORM) | Resolution: fixed
Severity: Normal | Triage Stage: Accepted
Keywords: | Needs documentation: 0
Has patch: 1 | Patch needs improvement: 0
Needs tests: 0 | UI/UX: 0
Easy pickings: 0 |
-------------------------------------+-------------------------------------
Changes (by Anssi Kääriäinen <akaariai@…>):
* status: new => closed
* resolution: => fixed
Comment:
In [changeset:"dfadbdac6a63dce3304dff1977b5b0a15dc2d7b5"]:
{{{
#!CommitTicketReference repository=""
revision="dfadbdac6a63dce3304dff1977b5b0a15dc2d7b5"
Fixed #16426 -- deletion of 1000+ objects with relations on SQLite
SQLite doesn't work with more than 1000 parameters in a single query.
The deletion code could generate queries that try to get related
objects for more than 1000 objects thus breaking the limit. Django now
splits the related object fetching into batches with at most 1000
parameters.
The tests and patch include some work done by Trac alias NiGhTTraX in
ticket #21205.
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/16426#comment:18>
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 [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/066.b0f0743ce8438e3af8a4f520e0ab0454%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
