Postgres Pro
Downloads
Home   >   mailing lists

pgsql: Prevent corr() from returning the wrong results for negative - Mailing list pgsql-committers

From neilc@postgresql.org (Neil Conway)
Subject pgsql: Prevent corr() from returning the wrong results for negative
Date
Msg-id 20070919223151.367FF753E4C@cvs.postgresql.org
Whole thread Raw
List pgsql-committers
Tree view 
Log Message:
-----------
Prevent corr() from returning the wrong results for negative correlation
values. The previous coding essentially assumed that x = sqrt(x*x), which
does not hold for x < 0.

Thanks to Jie Zhang at Greenplum and Gavin Sherry for reporting this
issue.

Tags:
----
REL8_2_STABLE

Modified Files:
--------------
    pgsql/src/backend/utils/adt:
        float.c (r1.130 -> r1.130.2.1)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/float.c?r1=1.130&r2=1.130.2.1)

pgsql-committers by date:

Previous
From: kocka@pgfoundry.org (User Kocka)
Date:
Subject: jdbccache - jdbccache:
Next
From: neilc@postgresql.org (Neil Conway)
Date:
Subject: pgsql: Prevent corr() from returning the wrong results for negative