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
16624	select_related does not return the objects related	eguevara2012@…	nobody	"Hello!
I cannot get the related objects of my class Endereco:

class Endereco(models.Model):
    # other fields
    imovel = models.ForeignKey(Imovel, blank=True, null=True)

Without using the select_related:

def search_imovel(request): 
    if request.method == 'POST':
        form = SearchImovelForm(request.POST)
        if form.is_valid():            
            quartos = form.cleaned_data['quartos']

            results = Imovel.objects.filter(quartos__exact = quartos)
            
            if results:
                return render_to_response('imobiliaria/index/results_imovel.html',{'results':results}, context_instance=RequestContext(request))

This is the output:

[<Imovel: Apartamento na Barra da Tijuca, 150000.00, 2>]
SELECT ""imovel_imovel"".""id"", ""imovel_imovel"".""codigo"", ""imovel_imovel"".""titulo"", ""imovel_imovel"".""area"", ""imovel_imovel"".""medida"", ""imovel_imovel"".""data_inclusao"", ""imovel_imovel"".""valor"", ""imovel_imovel"".""descricao"", ""imovel_imovel"".""quartos"", ""imovel_imovel"".""destaque"", ""imovel_imovel"".""slug"", ""imovel_imovel"".""cliente_id"", ""imovel_imovel"".""modalidade_id"", ""imovel_imovel"".""status_id"", ""imovel_imovel"".""tipo_id"" FROM ""imovel_imovel"" WHERE ""imovel_imovel"".""quartos"" = 2 

Now, using select_related():

def search_imovel(request): 
    if request.method == 'POST':
        form = SearchImovelForm(request.POST)
        if form.is_valid():            
            quartos = form.cleaned_data['quartos']

            results = Endereco.objects.select_related('imovel').filter(imovel__quartos__exact = quartos)
            
            if results:
                return render_to_response('imobiliaria/index/results_imovel.html',{'results':results}, context_instance=RequestContext(request))

This is the output:

[<Endereco: Av. Juliano Peixoto, 455, Centro, São Paulo, SP>]
SELECT ""endereco_endereco"".""id"", ""endereco_endereco"".""logradouro"", ""endereco_endereco"".""numero"", ""endereco_endereco"".""complemento"", ""endereco_endereco"".""bairro"", ""endereco_endereco"".""cidade"", ""endereco_endereco"".""estado"", ""endereco_endereco"".""cep"", ""endereco_endereco"".""pais"", ""endereco_endereco"".""imovel_id"", ""endereco_endereco"".""cliente_id"", ""imovel_imovel"".""id"", ""imovel_imovel"".""codigo"", ""imovel_imovel"".""titulo"", ""imovel_imovel"".""area"", ""imovel_imovel"".""medida"", ""imovel_imovel"".""data_inclusao"", ""imovel_imovel"".""valor"", ""imovel_imovel"".""descricao"", ""imovel_imovel"".""quartos"", ""imovel_imovel"".""destaque"", ""imovel_imovel"".""slug"", ""imovel_imovel"".""cliente_id"", ""imovel_imovel"".""modalidade_id"", ""imovel_imovel"".""status_id"", ""imovel_imovel"".""tipo_id"" FROM ""endereco_endereco"" LEFT OUTER JOIN ""imovel_imovel"" ON (""endereco_endereco"".""imovel_id"" = ""imovel_imovel"".""id"") WHERE ""imovel_imovel"".""quartos"" = 2 

It takes only endereco object and ignores the imovel object.
Does anyone know why this behavior?
Regards!
"	Bug	closed	Core (Serialization)	1.3	Normal	invalid	queryset		Unreviewed	0	0	0	0	0	0