#19112: regressiontests.queries.tests.ConditionalTests.test_ticket14244 breaks
mssql due to arbitrary maximum parameters
----------------------------------------------+--------------------
Reporter: manfre | Owner: manfre
Type: Cleanup/optimization | Status: new
Component: Database layer (models, ORM) | Version: master
Severity: Normal | Keywords:
Triage Stage: Unreviewed | Has patch: 1
Easy pickings: 0 | UI/UX: 0
----------------------------------------------+--------------------
`supports_1000_query_parameters` is a feature that was added (#14244) for
the sake of sqlite3 to prevent running the test
`regressiontests.queries.tests.ConditionalTests.test_ticket14244`. This
test asserts that a progressively larger number of parameters
(1000-2500)can be used.
Another purpose of the test appears to be a way of checking the behavior
of `max_in_list_size()`, which was added with ticket #14244 to fix
Oracle's limitation of at most 1000 values in an "IN" list.
Django-mssql, due to a driver limitation, supports a maximum of 2100
parameters for the entire query, not just the IN clause. I'd like to
propose lowering the final assert of 2500 to 2001 to still test a third IN
clause (for Oracle) while lowering the limit below what the mssql driver
can handle.
--
Ticket URL: <https://code.djangoproject.com/ticket/19112>
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 post to this group, send email to django-updates@googlegroups.com.
To unsubscribe from this group, send email to
django-updates+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
