openerp-expert-framework team mailing list archive

["Borja López Soilán (Pexego)" <borjals@xxxxxxxxx>]

Fabien Pinckaers-2 [via openerp-expert-framework] wrote:
> Hello,
>
> > Nevertheless it causes already problems with
> >
> > * filters ( "equal 0" and "not equal 0") (see Bug 654861
> > <https://bugs.launchpad.net/bugs/654861> )
>
> This is not related to rounding issues. Filters are performed at
> PostgreSQL layer and postgreSQL store and compute values in Decimal. So,
> you can not use rounding issues on such view.

Fabien, your comment applies to bug 654861 
<https://bugs.launchpad.net/bugs/654861> but not to bug 656378 
<https://bugs.launchpad.net/openobject-addons/+bug/656378>.

In bug 656378 it is obvious that the comparison is done at python level 
and it is making the mistake of not using an epsilon 
(http://www.cygnus-software.com/papers/comparingfloats/comparingfloats.htm 
<http://www.cygnus-software.com/papers/comparingfloats/comparingfloats.htm>).

Anyway, on bug 654861, even if the filter is being done properly (that's 
true), we still have an usability problem: The user can select to filter 
by "Qty", but it is not clear on the UI that this filter is done before 
grouping (WHERE) and not after grouping (HAVING): It  looks like we are 
filtering the groups, not the records, because the manual filters appear 
after the "Group by" expandable area (the seem to be part of that area).

Regards.

-- 
Borja López Soilán
borjals@xxxxxxxxx

Pexego Sistemas Informáticos S.L.
Avenida de Magoi 66 - 27002 Lugo (España)
Tel./Fax 982801517
http://www.pexego.es 


AVISO LEGAL - CLÁUSULA DE PRIVACIDAD
Este mensaje se dirige exclusivamente a su destinatario y puede contener información privilegiada o confidencial. Si no es usted el destinatario indicado, queda informado de que la utilización, divulgación y/o copia sin autorización está prohibida en virtud de la legislación vigente. Si ha recibido este mensaje por error, le rogamos que nos lo comunique inmediatamente por esta misma vía y proceda a su destrucción. 


-- 
View this message in context: http://openerp-expert-framework.71550.n3.nabble.com/rounding-float-errors-various-issues-with-0-0-tp1664297p1664921.html
Sent from the openerp-expert-framework mailing list archive at Nabble.com.