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
22973	cannot get SQL code of empty queryset	emanuele.paolini@…	Anderson Resende	"Suppose you have defined any Model class.

The code:
{{{
str(Model.objects.filter(id__in=[]).query)

}}}

raises an exception:


{{{
Traceback (most recent call last):
  File ""<console>"", line 1, in <module>
  File ""/usr/local/lib/python2.7/dist-packages/django/db/models/sql/query.py"", line 174, in __str__
    sql, params = self.sql_with_params()
  File ""/usr/local/lib/python2.7/dist-packages/django/db/models/sql/query.py"", line 182, in sql_with_params
    return self.get_compiler(DEFAULT_DB_ALIAS).as_sql()
  File ""/usr/local/lib/python2.7/dist-packages/django/db/models/sql/compiler.py"", line 85, in as_sql
    where, w_params = self.query.where.as_sql(qn=qn, connection=self.connection)
  File ""/usr/local/lib/python2.7/dist-packages/django/db/models/sql/where.py"", line 126, in as_sql
    raise EmptyResultSet
EmptyResultSet

}}}

instead this works fine:

{{{
str(Model.objects.none().query)
}}}
"	Bug	closed	Database layer (models, ORM)	1.5	Normal	wontfix		Tim Graham	Accepted	0	0	0	0	0	0