LIMIT works on entire queryset, even when not expected to.

[anonymous]

Class MyParent(models.Model):
    x = models.IntegerField()

Class MyChild(models.Model):
    parent = models.ForeignKey(MyParent)
    y      = models.IntegerField()

x = MyModel1.objects.all()[:5]
x.values('x', 'mychild')

The resulting queryset will possibly return less than 5 objects and then possibly not all of their children (because it adds 'LIMIT 5' to the entire SQL query instead of making one query with 'LIMIT 5' and another one with the join).

[Luke Plant]

I cannot understand the example code - it seems to have several errors. Can you post a corrected example, and re-open? I'm struggling to understand what the bug is as well, and what join you are referring to.