summing Decimal returns float instead of Decimal

[Matt Haggard]

When summing a Decimal, a float is returned instead of a decimal:

store.execute(Select(Sum(Foo.amount))).get_one()[0]

where Foo.amount is a Decimal() and the sqlite amount is numeric(12,2)

Also,

store.find(Foo).sum(Foo.amount)

raises an exception

[Matt Haggard (iffy)]

I'm not sure I like the test_select_decimal test I made. It's a little specific -- I mean, shouldn't I test all types, not just the Decimal type with the Sum function?

[Matt Haggard (iffy)]

Hmm... so part of the problem is with sqlite. Sqlite returns a float where postgres returns a Decimal.

[Matt Haggard (iffy)]

This fixes test_find_sum_decimal for sqlite -- I have not tested any other db

test_select_decimal is still not fixed, nor do I know if it can accurately be fixed.