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
3501	[patch] sqlite selection on datetime members fail when datefield is null	anonymous	Peter Baumgartner	"Doing selects like {{{model.objects.filter(datefield__year=2007)}}} fail when a datefield contains a NULL value.
Patch follows as a code block:

{{{

Index: django/db/backends/sqlite3/base.py
===================================================================
--- django/db/backends/sqlite3/base.py	(revision 4501)
+++ django/db/backends/sqlite3/base.py	(working copy)
@@ -119,6 +119,7 @@
     return 'django_extract(""%s"", %s)' % (lookup_type.lower(), table_name)
 
 def _sqlite_extract(lookup_type, dt):
+    if not dt: return None
     try:
         dt = util.typecast_timestamp(dt)
     except (ValueError, TypeError):

}}}

Thanks for all the good work!

Niels Poppe"		closed	Database layer (models, ORM)	dev		fixed	sqlite		Accepted	1	0	1	0	0	0