﻿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
30879	Nested foreign key test failures on Django 3.0 with SQLite 3.30.	Chris Lamb	nobody	"Hi,

I am seeing the following test failures for the 3.0~beta1 release:

{{{
======================================================================
FAIL: test_explicit_ForeignKey (nested_foreign_keys.tests.DeeplyNestedForeignKeysTests)
----------------------------------------------------------------------
Traceback (most recent call last):
  File ""/usr/lib/python3.7/unittest/case.py"", line 59, in testPartExecutor
    yield
  File ""/usr/lib/python3.7/unittest/case.py"", line 628, in run
    testMethod()
  File ""/<<PKGBUILDDIR>>/tests/nested_foreign_keys/tests.py"", line 176, in test_explicit_ForeignKey
    self.assertEqual(Package.objects.exclude(screening__movie__director=self.director).count(), 1)
  File ""/usr/lib/python3.7/unittest/case.py"", line 852, in assertEqual
    assertion_func(first, second, msg=msg)
  File ""/usr/lib/python3.7/unittest/case.py"", line 845, in _baseAssertEqual
    raise self.failureException(msg)
AssertionError: 0 != 1

======================================================================
FAIL: test_inheritance (nested_foreign_keys.tests.DeeplyNestedForeignKeysTests)
----------------------------------------------------------------------
Traceback (most recent call last):
  File ""/usr/lib/python3.7/unittest/case.py"", line 59, in testPartExecutor
    yield
  File ""/usr/lib/python3.7/unittest/case.py"", line 628, in run
    testMethod()
  File ""/<<PKGBUILDDIR>>/tests/nested_foreign_keys/tests.py"", line 153, in test_inheritance
    self.assertEqual(Event.objects.exclude(screening__movie__director=self.director).count(), 1)
  File ""/usr/lib/python3.7/unittest/case.py"", line 852, in assertEqual
    assertion_func(first, second, msg=msg)
  File ""/usr/lib/python3.7/unittest/case.py"", line 845, in _baseAssertEqual
    raise self.failureException(msg)
AssertionError: 0 != 1

======================================================================
FAIL: test_explicit_ForeignKey (nested_foreign_keys.tests.NestedForeignKeysTests)
----------------------------------------------------------------------
Traceback (most recent call last):
  File ""/usr/lib/python3.7/unittest/case.py"", line 59, in testPartExecutor
    yield
  File ""/usr/lib/python3.7/unittest/case.py"", line 628, in run
    testMethod()
  File ""/<<PKGBUILDDIR>>/tests/nested_foreign_keys/tests.py"", line 100, in test_explicit_ForeignKey
    self.assertEqual(Package.objects.exclude(screening__movie=self.movie).count(), 1)
  File ""/usr/lib/python3.7/unittest/case.py"", line 852, in assertEqual
    assertion_func(first, second, msg=msg)
  File ""/usr/lib/python3.7/unittest/case.py"", line 845, in _baseAssertEqual
    raise self.failureException(msg)
AssertionError: 0 != 1

======================================================================
FAIL: test_explicit_ForeignKey_NullFK (nested_foreign_keys.tests.NestedForeignKeysTests)
----------------------------------------------------------------------
Traceback (most recent call last):
  File ""/usr/lib/python3.7/unittest/case.py"", line 59, in testPartExecutor
    yield
  File ""/usr/lib/python3.7/unittest/case.py"", line 628, in run
    testMethod()
  File ""/<<PKGBUILDDIR>>/tests/nested_foreign_keys/tests.py"", line 121, in test_explicit_ForeignKey_NullFK
    self.assertEqual(PackageNullFK.objects.exclude(screening__movie=self.movie).count(), 2)
  File ""/usr/lib/python3.7/unittest/case.py"", line 852, in assertEqual
    assertion_func(first, second, msg=msg)
  File ""/usr/lib/python3.7/unittest/case.py"", line 845, in _baseAssertEqual
    raise self.failureException(msg)
AssertionError: 1 != 2

======================================================================
FAIL: test_inheritance (nested_foreign_keys.tests.NestedForeignKeysTests)
----------------------------------------------------------------------
Traceback (most recent call last):
  File ""/usr/lib/python3.7/unittest/case.py"", line 59, in testPartExecutor
    yield
  File ""/usr/lib/python3.7/unittest/case.py"", line 628, in run
    testMethod()
  File ""/<<PKGBUILDDIR>>/tests/nested_foreign_keys/tests.py"", line 53, in test_inheritance
    self.assertEqual(Event.objects.exclude(screening__movie=self.movie).count(), 1)
  File ""/usr/lib/python3.7/unittest/case.py"", line 852, in assertEqual
    assertion_func(first, second, msg=msg)
  File ""/usr/lib/python3.7/unittest/case.py"", line 845, in _baseAssertEqual
    raise self.failureException(msg)
AssertionError: 0 != 1

======================================================================
FAIL: test_inheritance_null_FK (nested_foreign_keys.tests.NestedForeignKeysTests)
----------------------------------------------------------------------
Traceback (most recent call last):
  File ""/usr/lib/python3.7/unittest/case.py"", line 59, in testPartExecutor
    yield
  File ""/usr/lib/python3.7/unittest/case.py"", line 628, in run
    testMethod()
  File ""/<<PKGBUILDDIR>>/tests/nested_foreign_keys/tests.py"", line 72, in test_inheritance_null_FK
    self.assertEqual(Event.objects.exclude(screeningnullfk__movie=self.movie).count(), 2)
  File ""/usr/lib/python3.7/unittest/case.py"", line 852, in assertEqual
    assertion_func(first, second, msg=msg)
  File ""/usr/lib/python3.7/unittest/case.py"", line 845, in _baseAssertEqual
    raise self.failureException(msg)
AssertionError: 1 != 2

======================================================================
FAIL: test_ticket7076 (queries.tests.Queries1Tests)
----------------------------------------------------------------------
Traceback (most recent call last):
  File ""/usr/lib/python3.7/unittest/case.py"", line 59, in testPartExecutor
    yield
  File ""/usr/lib/python3.7/unittest/case.py"", line 628, in run
    testMethod()
  File ""/<<PKGBUILDDIR>>/tests/queries/tests.py"", line 806, in test_ticket7076
    ['<Tag: t1>', '<Tag: t4>', '<Tag: t5>']
  File ""/<<PKGBUILDDIR>>/django/test/testcases.py"", line 1056, in assertQuerysetEqual
    return self.assertEqual(list(items), values, msg=msg)
  File ""/usr/lib/python3.7/unittest/case.py"", line 852, in assertEqual
    assertion_func(first, second, msg=msg)
  File ""/usr/lib/python3.7/unittest/case.py"", line 1058, in assertListEqual
    self.assertSequenceEqual(list1, list2, msg, seq_type=list)
  File ""/usr/lib/python3.7/unittest/case.py"", line 1040, in assertSequenceEqual
    self.fail(msg)
  File ""/usr/lib/python3.7/unittest/case.py"", line 693, in fail
    raise self.failureException(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>']
?          ^           +++++++++++++


----------------------------------------------------------------------
Ran 13071 tests in 180.966s

FAILED (failures=7, skipped=891, expected failures=4)
}}}

The full build log can be found here: https://buildd.debian.org/status/fetch.php?pkg=python-django&arch=all&ver=2%3A3.0~beta1-1&stamp=1571079369&file=log"	Bug	closed	Database layer (models, ORM)	3.0	Normal	invalid		Simon Charette	Unreviewed	0	0	0	0	0	0
