Opened 13 years ago

Closed 13 years ago

#16480 closed Bug (fixed)

DeferRegressionTest.test_basic fails under Oracle

Reported by: Aymeric Augustin Owned by: nobody
Component: Database layer (models, ORM) Version: 1.3
Severity: Release blocker Keywords:
Cc: Triage Stage: Unreviewed
Has patch: no Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

Description

$ python runtests.py --settings=test_settings.oracle defer_regress
Creating test database for alias 'default'...
Creating test user...
Creating test database for alias 'other'...
Creating test user...
E..
======================================================================
ERROR: test_basic (regressiontests.defer_regress.tests.DeferRegressionTest)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/var/lib/jenkins/jobs/Django/workspace/settings/oracle/tests/regressiontests/defer_regress/tests.py", line 151, in test_basic
    self.assertIsInstance(list(Item.objects.annotate(Count('relateditem')).defer('name')), list)
  File "/var/lib/jenkins/jobs/Django/workspace/settings/oracle/django/db/models/query.py", line 81, in __len__
    self._result_cache.extend(self._iter)
  File "/var/lib/jenkins/jobs/Django/workspace/settings/oracle/django/db/models/query.py", line 270, in iterator
    for row in compiler.results_iter():
  File "/var/lib/jenkins/jobs/Django/workspace/settings/oracle/django/db/models/sql/compiler.py", line 699, in results_iter
    for rows in self.execute_sql(MULTI):
  File "/var/lib/jenkins/jobs/Django/workspace/settings/oracle/django/db/models/sql/compiler.py", line 754, in execute_sql
    cursor.execute(sql, params)
  File "/var/lib/jenkins/jobs/Django/workspace/settings/oracle/django/db/backends/oracle/base.py", line 638, in execute
    return self.cursor.execute(query, self._param_generator(params))
DatabaseError: ORA-00932: inconsistent datatypes: expected - got NCLOB


----------------------------------------------------------------------
Ran 3 tests in 0.567s

FAILED (errors=1)
Destroying test database for alias 'default'...
Destroying test user...
Destroying test database tables...
Destroying test database for alias 'other'...
Destroying test user...
Destroying test database tables...

Change History (1)

comment:1 by Ramiro Morales, 13 years ago

Resolution: fixed
Status: newclosed

In [16546]:

Fixed #16480 -- Modified test added in r16522 so it doesn't use a query not supported under Oracle (GROUP BY a NCLOB field). Thanks Aymeric for the report. Refs #4186

Note: See TracTickets for help on using tickets.
Back to Top