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
11662	Filtered Queryset update() on a Proxy Model updates all records	stryderjzw	nobody	"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 } }}}"		closed	Database layer (models, ORM)	1.1		worksforme			Accepted	0	0	0	0	0	0