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
4464	Chaining filters on ManyToManyFields broken?	ml_django25@…	nobody	"The last part of this fails (with MySql 5):

{{{
from django.db import models

class Category(models.Model):
    name=models.CharField(maxlength=40)

class Thing(models.Model):
    """"""
    >>> cat1 = Category.objects.create(name=""cat2"")
    >>> cat1.save()
    >>> cat2 = Category.objects.create(name=""cat2"")
    >>> cat2.save()
    >>> my_thing = Thing.objects.create(name=""My thing"")
    >>> my_thing.save()
    >>> my_thing.categories = [cat1, cat2]
    >>> Thing.objects.filter(categories=cat1)
    [<Thing: My thing>]
    >>> Thing.objects.filter(categories=cat2)
    [<Thing: My thing>]
    >>> Thing.objects.filter(categories=cat1).filter(categories=cat2)
    [<Thing: My thing>]
    """"""
    name=models.CharField(maxlength=40)
    categories = models.ManyToManyField(Category)
    def __str__(self):
        return self.name
}}}

Am I right in thinking that ought to pass?"		closed	Database layer (models, ORM)	dev		fixed	manytomany, manytomanyfield, qs-rf-fixed	b-django@…	Accepted	0	0	0	0	0	0