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
23843	Test failures on Oracle/Python3	Shai Berger		"On CI, as well as on my system:

{{{
ERROR: test_custom_functions (annotations.tests.NonAggregateAnnotationTestCase)
----------------------------------------------------------------------
Traceback (most recent call last):
  File ""/home/django/django/django/db/backends/utils.py"", line 65, in execute
    return self.cursor.execute(sql, params)
  File ""/home/django/django/django/db/backends/oracle/base.py"", line 916, in execute
    return self.cursor.execute(query, self._param_generator(params))
cx_Oracle.DatabaseError: ORA-12704: character set mismatch


The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File ""/home/django/django/tests/annotations/tests.py"", line 254, in test_custom_functions
    lambda c: (c.name, c.tagline)
  File ""/home/django/django/django/test/testcases.py"", line 869, in assertQuerysetEqual
    items = six.moves.map(transform, qs)
  File ""/home/django/django/django/db/models/query.py"", line 161, in __iter__
    self._fetch_all()
  File ""/home/django/django/django/db/models/query.py"", line 989, in _fetch_all
    self._result_cache = list(self.iterator())
  File ""/home/django/django/django/db/models/query.py"", line 289, in iterator
    for row in compiler.results_iter():
  File ""/home/django/django/django/db/models/sql/compiler.py"", line 720, in results_iter
    for rows in self.execute_sql(MULTI):
  File ""/home/django/django/django/db/models/sql/compiler.py"", line 817, in execute_sql
    cursor.execute(sql, params)
  File ""/home/django/django/django/db/backends/utils.py"", line 65, in execute
    return self.cursor.execute(sql, params)
  File ""/home/django/django/django/db/utils.py"", line 95, in __exit__
    six.reraise(dj_exc_type, dj_exc_value, traceback)
  File ""/home/django/django/django/utils/six.py"", line 624, in reraise
    raise value.with_traceback(tb)
  File ""/home/django/django/django/db/backends/utils.py"", line 65, in execute
    return self.cursor.execute(sql, params)
  File ""/home/django/django/django/db/backends/oracle/base.py"", line 916, in execute
    return self.cursor.execute(query, self._param_generator(params))
django.db.utils.DatabaseError: ORA-12704: character set mismatch


======================================================================
ERROR: test_custom_functions_can_ref_other_functions (annotations.tests.NonAggregateAnnotationTestCase)
----------------------------------------------------------------------
Traceback (most recent call last):
  File ""/home/django/django/django/db/backends/utils.py"", line 65, in execute
    return self.cursor.execute(sql, params)
  File ""/home/django/django/django/db/backends/oracle/base.py"", line 916, in execute
    return self.cursor.execute(query, self._param_generator(params))
cx_Oracle.DatabaseError: ORA-12704: character set mismatch


The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File ""/home/django/django/tests/annotations/tests.py"", line 287, in test_custom_functions_can_ref_other_functions
    lambda c: (c.name, c.tagline_lower)
  File ""/home/django/django/django/test/testcases.py"", line 869, in assertQuerysetEqual
    items = six.moves.map(transform, qs)
  File ""/home/django/django/django/db/models/query.py"", line 161, in __iter__
    self._fetch_all()
  File ""/home/django/django/django/db/models/query.py"", line 989, in _fetch_all
    self._result_cache = list(self.iterator())
  File ""/home/django/django/django/db/models/query.py"", line 289, in iterator
    for row in compiler.results_iter():
  File ""/home/django/django/django/db/models/sql/compiler.py"", line 720, in results_iter
    for rows in self.execute_sql(MULTI):
  File ""/home/django/django/django/db/models/sql/compiler.py"", line 817, in execute_sql
    cursor.execute(sql, params)
  File ""/home/django/django/django/db/backends/utils.py"", line 65, in execute
    return self.cursor.execute(sql, params)
  File ""/home/django/django/django/db/utils.py"", line 95, in __exit__
    six.reraise(dj_exc_type, dj_exc_value, traceback)
  File ""/home/django/django/django/utils/six.py"", line 624, in reraise
    raise value.with_traceback(tb)
  File ""/home/django/django/django/db/backends/utils.py"", line 65, in execute
    return self.cursor.execute(sql, params)
  File ""/home/django/django/django/db/backends/oracle/base.py"", line 916, in execute
    return self.cursor.execute(query, self._param_generator(params))
django.db.utils.DatabaseError: ORA-12704: character set mismatch
}}}
"	Bug	new	Database layer (models, ORM)	dev	Normal				Accepted	0	0	0	0	0	0