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
31001	Test failures on SQLite 3.30.	Nick Pope	nobody	"I'm encountering the following test failures in the Django test suite on SQLite 3.30.0+:

{{{
======================================================================
FAIL: test_explicit_ForeignKey (nested_foreign_keys.tests.DeeplyNestedForeignKeysTests)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "".../django/tests/nested_foreign_keys/tests.py"", line 176, in test_explicit_ForeignKey
    self.assertEqual(Package.objects.exclude(screening__movie__director=self.director).count(), 1)
AssertionError: 0 != 1

======================================================================
FAIL: test_inheritance (nested_foreign_keys.tests.DeeplyNestedForeignKeysTests)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "".../django/tests/nested_foreign_keys/tests.py"", line 153, in test_inheritance
    self.assertEqual(Event.objects.exclude(screening__movie__director=self.director).count(), 1)
AssertionError: 0 != 1

======================================================================
FAIL: test_explicit_ForeignKey (nested_foreign_keys.tests.NestedForeignKeysTests)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "".../django/tests/nested_foreign_keys/tests.py"", line 100, in test_explicit_ForeignKey
    self.assertEqual(Package.objects.exclude(screening__movie=self.movie).count(), 1)
AssertionError: 0 != 1

======================================================================
FAIL: test_explicit_ForeignKey_NullFK (nested_foreign_keys.tests.NestedForeignKeysTests)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "".../django/tests/nested_foreign_keys/tests.py"", line 121, in test_explicit_ForeignKey_NullFK
    self.assertEqual(PackageNullFK.objects.exclude(screening__movie=self.movie).count(), 2)
AssertionError: 1 != 2

======================================================================
FAIL: test_inheritance (nested_foreign_keys.tests.NestedForeignKeysTests)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "".../django/tests/nested_foreign_keys/tests.py"", line 53, in test_inheritance
    self.assertEqual(Event.objects.exclude(screening__movie=self.movie).count(), 1)
AssertionError: 0 != 1

======================================================================
FAIL: test_inheritance_null_FK (nested_foreign_keys.tests.NestedForeignKeysTests)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "".../django/tests/nested_foreign_keys/tests.py"", line 72, in test_inheritance_null_FK
    self.assertEqual(Event.objects.exclude(screeningnullfk__movie=self.movie).count(), 2)
AssertionError: 1 != 2

======================================================================
FAIL: test_ticket7076 (queries.tests.Queries1Tests)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "".../django/tests/queries/tests.py"", line 806, in test_ticket7076
    ['<Tag: t1>', '<Tag: t4>', '<Tag: t5>']
  File "".../django/django/test/testcases.py"", line 1043, in assertQuerysetEqual
    return self.assertEqual(list(items), values, msg=msg)
AssertionError: Lists differ: ['<Tag: t4>', '<Tag: t5>'] != ['<Tag: t1>', '<Tag: t4>', '<Tag: t5>']

First differing element 0:
'<Tag: t4>'
'<Tag: t1>'

Second list contains 1 additional elements.
First extra element 2:
'<Tag: t5>'

- ['<Tag: t4>', '<Tag: t5>']
?          ^

+ ['<Tag: t1>', '<Tag: t4>', '<Tag: t5>']
?          ^           +++++++++++++
}}}

I haven't managed to identify the cause yet. It is likely that a bug needs to be filed for SQLite, but we may need to workaround it in Django."	Bug	closed	Database layer (models, ORM)	dev	Normal	duplicate	sqlite		Unreviewed	0	0	0	0	0	0