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
26219	Cannot filter by DecimalField in RawQuery	jirek	Akshesh Doshi	"
{{{
#!python

class Product(models.Model):
    name = models.CharField(max_length=128)
    price = models.DecimalField(max_digits=15, decimal_places=2, default=0, blank=True)

products = Product.objects.raw("""""" SELECT * FROM ""products_product"" WHERE price >= %s """""", params=[Decimal(200), ])
for product in products:
    print product
}}}

this will raise following exception
{{{
#!python

File ""site-packages\django\db\models\query.py"", line 1219, in __iter__
    query = iter(self.query)
  File ""site-packages\django\db\models\sql\query.py"", line 79, in __iter__
    self._execute_query()
  File ""site-packages\django\db\models\sql\query.py"", line 106, in _execute_query
    params = tuple(adapter(val) for val in self.params)
  File ""site-packages\django\db\models\sql\query.py"", line 106, in <genexpr>
    params = tuple(adapter(val) for val in self.params)
  File ""site-packages\django\db\backends\base\operations.py"", line 455, in adapt_unknown_value
    return self.adapt_decimalfield_value(value)
TypeError: adapt_decimalfield_value() takes exactly 4 arguments (2 given)
}}}

We are making much more complex query, this is just simple example of bug we are challenging
"	Bug	closed	Database layer (models, ORM)	1.9	Release blocker	fixed	DecimalField RawQuery		Accepted	1	0	1	0	1	0