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
7103	select_related doesn't traverse nullable FK relations even when explictitly specified.	Andy McCurdy <sedrik@…>	nobody	"Just updated my svn to latest trunk to get qs-rf merger.  Went to try to get select_related to work with some of my models with nullable foreign keys, and didn't have much luck.  Made a simple test to demonstrate this.  Documentation suggests that if explicitly specified, select_related should query nullable relations.
{{{
# models.py
from django.db import models

class Foo(models.Model):
    name = models.CharField(max_length=32)

class BarManager(models.Manager):
    def get_query_set(self):
        print ""selecting related...""
        return super(BarManager, self).get_query_set().select_related('foo')
    
class Bar(models.Model):
    foo = models.ForeignKey(Foo, null=True)
    name = models.CharField(max_length=32)
    
    objects = BarManager()
    


# console
In [1]: f = Foo(name='test_foo')

In [2]: f.save()

In [3]: b = Bar(name='tst_bar', foo=f)

In [4]: b.save()

In [5]: from django.db import connection

In [6]: b1 = Bar.objects.get(pk=1)
selecting related...

In [7]: connection.queries[-1]
Out[7]: 
[{'sql': 'SELECT ""test_bar"".""id"",""test_bar"".""foo_id"",""test_bar"".""name"" FROM ""test_bar"" WHERE (""test_bar"".""id"" = 1)',
  'time': '0.003'}]
}}}"		closed	Database layer (models, ORM)	dev		worksforme	select_related		Unreviewed	0	0	0	0	0	0