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
26680	more than one row returned by a subquery used as an expression	Maarten	nobody	"Summary:
In 1.8.13 the subquery has a compare to ""in"", in 1.9.6 to ""="". In my view 1.8 is correct.

The query:
{{{
leverancier_medew = Adresboek.objects.filter(
         klant_id=klant_id, 
         soort='leverancier', 
         leverancier=Leverancier.objects.filter(
                      klant_id=klant_id, 
                      locatie=melding.apparaat.locatie))
}}}

gives in 1.8.13

{{{
SELECT ""meldman_adresboek"".""id"",  etc.etc.
FROM ""meldman_adresboek"" 
WHERE (""meldman_adresboek"".""soort"" = 'leverancier' 
AND ""meldman_adresboek"".""klant_id"" = 24 
AND ""meldman_adresboek"".""leverancier_id"" IN 
  (SELECT U0.""id"" 
   FROM ""meldman_leverancier"" U0 
   INNER JOIN ""meldman_locatie_leverancier"" U2 ON (U0.""id"" = U2.""leverancier_id"") 
     WHERE (U0.""klant_id"" = 24 AND U2.""locatie_id"" = 75))) 
  ORDER BY ""meldman_adresboek"".""achternaam"" ASC, ""meldman_adresboek"".""voornaam"" ASC

}}}

The line:
{{{
   AND ""meldman_adresboek"".""leverancier_id"" IN
}}}
changes in 1.9.6 to
{{{
   AND ""meldman_adresboek"".""leverancier_id"" = 
}}}
which then returns the error: ""more than one row returned by a subquery used as an expression"".

My sincere thanks for your time and attention. 
Greetings,
Maarten"	Bug	closed	Database layer (models, ORM)	1.9	Normal	duplicate	ORM subquery multiple rows		Unreviewed	0	0	0	0	0	0