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
20528	QuerySet Q + select_related regression with multiple ForeignKeys	Tim Graham	nobody	"The attached test last passed in 3fef304ff237fe692459c1f5b840acf7886c50bb, generating the following query:
{{{
SELECT (fields)
FROM ""select_related_regress_childb""
LEFT OUTER JOIN ""select_related_regress_parent"" ON
  (""select_related_regress_childb"".""parent_id"" = ""select_related_regress_parent"".""id"")
LEFT OUTER JOIN ""select_related_regress_childa"" ON
  (""select_related_regress_childb"".""child_id"" = ""select_related_regress_childa"".""id"")
WHERE (""select_related_regress_childb"".""parent_id"" = 1
  OR ""select_related_regress_childa"".""parent_id"" = 1 )
}}}

The query changed in edf93127bf2f9dc35b45cdea5d39a1b417ab1638 (affects master/1.6 only) with the replacement of the first ""LEFT OUTER JOIN"" with an ""INNER JOIN"":
{{{
SELECT (fields)
FROM ""select_related_regress_childb""
INNER JOIN ""select_related_regress_parent"" ON
  (""select_related_regress_childb"".""parent_id"" = ""select_related_regress_parent"".""id"")
LEFT OUTER JOIN ""select_related_regress_childa"" ON
  (""select_related_regress_childb"".""child_id"" = ""select_related_regress_childa"".""id"")
WHERE (""select_related_regress_childb"".""parent_id"" = 1
  OR ""select_related_regress_childa"".""parent_id"" = 1 )
}}}"	Bug	closed	Database layer (models, ORM)	dev	Release blocker	fixed			Accepted	0	0	0	0	0	0