On Fri, Feb 3, 2017 at 3:49 AM, Tom Lane wrote:
> Ruben Buchatskiy writes:
>> We have found that in parallel mode result of queries is non-deterministic
>> when the types of the attributes in table are double precision
>> (floating-point).
>
> Yeah ...
>
>> That is because floating-point addition
Ruben Buchatskiy writes:
> We have found that in parallel mode result of queries is non-deterministic
> when the types of the attributes in table are double precision
> (floating-point).
Yeah ...
> That is because floating-point addition is not necessarily associative.
Right, exactly.
> Is thi
Hi hackers,
We have found that in parallel mode result of queries is non-deterministic
when the types of the attributes in table are double precision
(floating-point).
Our example is based on TPC-H, but some NUMERIC columns type was changed to
DOUBLE PRECISION;
When running without parallelism