#26063: Regression in Django 1.9: SQLite can no longer handle more than 2000
values
in a "foo__in" filter
-------------------------------------+-------------------------------------
Reporter: rhertzog | Owner: aaugustin
Type: Bug | Status: assigned
Component: Database layer | Version: 1.9
(models, ORM) |
Severity: Release blocker | Resolution:
Keywords: | Triage Stage: Accepted
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Comment (by tobald):
Aymeric Augustin wrote:
> If the reporter could test it and confirm that it fixes the issue, that
would be great.
I get an error futher:
{{{
File "/usr/lib/python2.7/dist-packages/django/db/models/query.py",
line 258, in __iter__
self._fetch_all()
File "/usr/lib/python2.7/dist-packages/django/db/models/query.py",
line 1074, in _fetch_all
self._result_cache = list(self.iterator())
File "/usr/lib/python2.7/dist-packages/django/db/models/query.py",
line 52, in __iter__
results = compiler.execute_sql()
File "/usr/lib/python2.7/dist-
packages/django/db/models/sql/compiler.py", line 852, in execute_sql
cursor.execute(sql, params)
File "/usr/lib/python2.7/dist-packages/django/db/backends/utils.py",
line 83, in execute
sql = self.db.ops.last_executed_query(self.cursor, sql, params)
File "/usr/lib/python2.7/dist-
packages/django/db/backends/sqlite3/operations.py", line 141, in
last_executed_query
return sql % params
TypeError: not enough arguments for format string
}}}
Here params is a list of 25000 integers.
Thanks,
Christophe
--
Ticket URL: <https://code.djangoproject.com/ticket/26063#comment:9>
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.dcbe48e3b84fe4489a4152308b5860af%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
