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
34227	Multi-level FilteredRelation with select_related() may set wrong related object.	zhu	zhu	"test case:
{{{
#!python
# add to known_related_objects.tests.ExistingRelatedInstancesTests
    def test_wrong_select_related(self):
        with self.assertNumQueries(3):
            p = list(PoolStyle.objects.annotate(
                tournament_pool=FilteredRelation('pool__tournament__pool'),
                ).select_related('tournament_pool'))
            self.assertEqual(p[0].pool.tournament, p[0].tournament_pool.tournament)

}}}
result:
{{{
======================================================================
FAIL: test_wrong_select_related (known_related_objects.tests.ExistingRelatedInstancesTests.test_wrong_select_related)
----------------------------------------------------------------------
Traceback (most recent call last):
  File ""D:\Work\django\tests\known_related_objects\tests.py"", line 171, in test_wrong_select_related
    self.assertEqual(p[0].pool.tournament, p[0].tournament_pool.tournament)
AssertionError: <Tournament: Tournament object (1)> != <PoolStyle: PoolStyle object (1)>

----------------------------------------------------------------------
}}}
"	Bug	closed	Database layer (models, ORM)	4.1	Normal	fixed			Ready for checkin	1	0	0	0	0	0