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
26983	"models.Manager query ""filter(field__isnull=False)"" not working in 1.10"	weidwonder	nobody	"models Manager:


{{{
class ModelManager(models.Manager):
    def get_queryset(self):
        return super(ModelManager, self).get_queryset().filter(parent__isnull=False)
}}}

models:


{{{
class Category(models.Model):
    parent = models.ForeignKey('Category', to_field='slug', db_column='parent',
                               max_length=32, blank=True, null=True,
                               related_name='models')
    name = models.CharField(max_length=50, blank=True, null=True)
    ....
    vehicle_models = ModelManager()

    class Meta:
        db_table = 'open_category'
        ordering = ['pinyin']

}}}

query:

{{{
Category.vehicle_models.filter(slug=model_slug).values('name').query
}}}

query's sql output is:


{{{
SELECT `open_category`.`name` FROM `open_category` WHERE (`open_category`.`parent` IS NULL AND `open_category`.`slug` = ""suteng"") ORDER BY `open_category`.`pinyin` ASC
}}}

it should be '''`open_category`.`parent` IS NOT NULL'''
"	Bug	new	Database layer (models, ORM)	1.10	Normal		queryset		Unreviewed	0	0	0	0	0	0