Filtered Queryset update() on a Proxy Model updates all records

[stryderjzw]

Here's my models:

class Item(models.Model):
    ...

class Bid(models.Model):
    ...
    item = models.ForeignKey(Item)
    processed = models.BooleanField(default=False)
    ...

class Transaction(Bid):
    class Meta:
        proxy = True  

When I run:

Transaction.objects.filter(processed=False, item=2).update(processed=True)

It would set all Transactions.processed to True, when I clearly only want the bids on item 2 to be processed.

I get this SQL:

{'time': '0.000', 'sql': 'UPDATE "game_bid" SET "processed" = true'}

However:

Bid.objects.filter(processed=False, item=2).update(processed=True)

This appears to work as intended.

SQL:

{'time': '0.000', 'sql': 'UPDATE "game_bid" SET "processed" = true WHERE ("game_bid"."item_id" = 6 AND "game_bid"."processed" = false }

[Johannes Dollinger]

I cannot reproduce this with r11638 on sqlite.

import unittest
from django.db import models, connection
from django.conf import settings

class Item(models.Model):
    pass

class Bid(models.Model):
    item = models.ForeignKey(Item)
    processed = models.BooleanField(default=False)

class Transaction(Bid):
    class Meta:
        proxy = True
    
class Tests(unittest.TestCase):
    def test_11662(self):
        item1 = Item.objects.create(id=1)
        item2 = Item.objects.create(id=2)
        
        Bid.objects.create(item=item1)
        Bid.objects.create(item=item2)

        Transaction.objects.filter(processed=False, item=item2).update(processed=True)
        self.assertEqual(Bid.objects.get(item=item1).processed, False)