id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
14441	Oracle list limit exceeded with __in filters	DavidMAM	nobody	"Trying to retrieve a set of objects based on field values. I build the set of values as an array

namelist=[]

.. some code that does namelist.append(name) many times

obl=MyObject.objects.filter(namefield__in=namelist)

obl.count()
if namelist is longer than 1000 then Oracle throws an error
Traceback (most recent call last):
  File ""<console>"", line 1, in <module>
  File ""/usr/local/lib/python2.6/site-packages/django/db/models/query.py"", line 292, in count
    return self.query.get_count()
  File ""/usr/local/lib/python2.6/site-packages/django/db/models/sql/query.py"", line 376, in get_count
    number = obj.get_aggregation()[None]
  File ""/usr/local/lib/python2.6/site-packages/django/db/models/sql/query.py"", line 348, in get_aggregation
    result = query.execute_sql(SINGLE)
  File ""/usr/local/lib/python2.6/site-packages/django/db/models/sql/query.py"", line 2369, in execute_sql
    cursor.execute(sql, params)
  File ""/usr/local/lib/python2.6/site-packages/django/db/backends/util.py"", line 19, in execute
    return self.cursor.execute(sql, params)
  File ""/usr/local/lib/python2.6/site-packages/django/db/backends/oracle/base.py"", line 443, in execute
    raise e
DatabaseError: ORA-01795: maximum number of expressions in a list is 1000

I don't know if there is an easy way to combine querysets as splitting them into batches of a suitable number would be no problem if they could be combined later."		new	Database layer (models, ORM)	1.1			Oracle		Unreviewed	0	0	0	0	0	0