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
6666	Oracle test case failure	Erin Kelly	Erin Kelly	"[7150] introduced a test case that fails in Oracle.  The traceback is:

{{{
File ""/home/ikelly/projects/django.trunk/tests/regressiontests/datatypes/models.py"", line ?, in regressiontests.datatypes.models.__test__.API_TESTS
Failed example:
    Donut.objects.filter(baked_date__year=2006)
Exception raised:
    Traceback (most recent call last):
      File ""/home/ikelly/projects/django.trunk/django/test/_doctest.py"", line 1267, in __run
        compileflags, 1) in test.globs
      File ""<doctest regressiontests.datatypes.models.__test__.API_TESTS[25]>"", line 1, in <module>
        Donut.objects.filter(baked_date__year=2006)
      File ""/home/ikelly/projects/django.trunk/django/db/models/query.py"", line 108, in __repr__
        return repr(self._get_data())
      File ""/home/ikelly/projects/django.trunk/django/db/models/query.py"", line 483, in _get_data
        self._result_cache = list(self.iterator())
      File ""/home/ikelly/projects/django.trunk/django/db/backends/oracle/base.py"", line 123, in iterator
        cursor.execute(full_query, params)
      File ""/home/ikelly/projects/django.trunk/django/db/backends/oracle/base.py"", line 506, in execute
        return Database.Cursor.execute(self, query, params)
    DatabaseError: ORA-01830: date format picture ends before converting entire input string
}}}

The generated query and bind parameters are:

{{{
SELECT ""DATATYPES_DONUT"".""ID"", ""DATATYPES_DONUT"".""NAME"", ""DATATYPES_DONUT"".""IS_FROSTED"", ""DATATYPES_DONUT"".""HAS_SPRINKLES"", ""DATATYPES_DONUT"".""BAKED_DATE"", ""DATATYPES_DONUT"".""BAKED_TIME"", ""DATATYPES_DONUT"".""CONSUMED_AT""
 FROM ""DATATYPES_DONUT"" WHERE (""DATATYPES_DONUT"".""BAKED_DATE"" BETWEEN :arg0 AND :arg1) ORDER BY ""DATATYPES_DONUT"".""CONSUMED_AT"" ASC

('2007-01-01 00:00:00', '2007-12-31 23:59:59.999999')
}}}
"		closed	Database layer (models, ORM)	dev		fixed	oracle		Accepted	0	0	0	0	0	0