Domain Calculation : Wrong behavior with 0.0

[Ferdinand]

filter does not exclude all 0.00 values as shown

the

'qty_available': fields.function(_product_available, method=True, type='float', string='Real Stock',

2 values returned by sum(qty_available) are
  5.6843418860808e-13
-1.77635683940025e-15

[Albert Cervera i Areny - http://www.NaN-tic.com (albert-nan)]

A Dilluns, 13 de setembre de 2010, Ferdinand @ ChriCar va escriure:
> ** Attachment added: "filter_rounding_issue.png"
>
> https://bugs.launchpad.net/bugs/636983/+attachment/1577278/+files/filter_r
> ounding_issue.png

This sounds like a server-side bug to me.

--
Albert Cervera i Areny
http://www.NaN-tic.com
OpenERP Partners
Mòbil: [phone]

http://twitter.com/albertnan
http://albert-nan.blogspot.com

[Ferdinand (office-chricar)]

IMHO a conceptual bug

product_qty = double precision in stock_move
I did aggregate with a psql statement
select sum(product_qty) ....
as it is widely done in accounting

Yes I know I can and will put round(sum( )) in my statement - because I can handle this now

but this will and must be a permanent source of errors if the filters are not smart enough

it's just because Koo is the first with filters like this (as GKT and web didn't allow filtering 0 in V5)

I post this as preventive bug for trunk

[Fabien (Open ERP) (fp-tinyerp)]

this is a limitation of the framework, we can not filter on a field.function unless a search method is implemented.
As it's a new feature request for this field, I set as wishlist.

[Ferdinand (office-chricar)]

@Fabien
it's not a question of not being able to filter, but to filter the correct values due to a rounding problem

[Ferdinand (office-chricar)]

unfortunatley I can not set the status back to NEW

[Jay Vora (Serpent Consulting Services) (jayvora)]

I will take a look again.
Probably,It is not an issue of search of functional fields, the title has been modified which says that the domain evaluates int/float wrongly.
Thanks.