Q Filter behavior change between Django 1.6.7 and Django 1.7

database

+------------+
|   Owners   |
+----+-------+
|id  |name   |
+----+-------+
|  1 |Alice  |
+----+-------+
|  2 |Bob    |
+----+-------+
|  3 |Steve  |
+----+-------+

+-------------------+
|       Pets        |
+----+------+-------+
|id  |name  |flies  |
+----+------+-------+
|  1 |Dog   |0      |
+----+------+-------+
|  2 |Cat   |0      |
+----+------+-------+
|  3 |Bird  |1      |
+----+------+-------+

+---------------------------------+
|            PetOwners            |
+----+----------+--------+--------+
|id  |owner_id  |pet_id  |name    |
+----+----------+--------+--------+
|  1 |        1 |      1 |Rover   |
+----+----------+--------+--------+
|  2 |        1 |      3 |Birdo   |
+----+----------+--------+--------+
|  3 |        2 |      2 |Lion-o  |
+----+----------+--------+--------+
|  4 |        3 |      3 |Polly   |
+----+----------+--------+--------+

models.py

from django.db import models


class Owner(models.Model):
    name = models.CharField(max_length=30)
    
    def __unicode__(self):
        return self.name


class Pet(models.Model):
    name = models.CharField(max_length=30)
    flies = models.BooleanField(default=False)


class PetOwner(models.Model):
    owner = models.ForeignKey(Owner)
    pet = models.ForeignKey(Pet)
    name = models.CharField(max_length=30)

q_filter_diff

>>> from django.db.models import Q
>>> from myapp.models import Owner, Pet, PetOwner

>>> # Get owners who only have pets that can't fly. (Expected: <Owner: Bob>)
>>> q_obj = Q(Q(petowner__pet__flies=False), ~Q(petowner__pet__flies=True))


### In Django 1.6 ###
>>> Owner.objects.filter(q_obj)
[<Owner: Bob>]


### In Django 1.7 ###
>>> Owner.objects.filter(q_obj)
[<Owner: Alice>, <Owner: Bob>]