Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #18240: Undefined behaviour in cash_mul_flt8() and friends - Mailing list pgsql-bugs

From Michael Paquier
Subject Re: BUG #18240: Undefined behaviour in cash_mul_flt8() and friends
Date
Msg-id ZXbi3xo7QhQIe1YN@paquier.xyz
Whole thread Raw
In response to BUG #18240: Undefined behaviour in cash_mul_flt8() and friends  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #18240: Undefined behaviour in cash_mul_flt8() and friends
List pgsql-bugs
Tree view 
On Mon, Dec 11, 2023 at 06:00:02AM +0000, PG Bug reporting form wrote:
> The following multiplication:
> SELECT 1_000_000_000::money * 1_000_000_000::float8;
>
> gives the incorrect result:
>  -$92,233,720,368,547,758.08

Yep, good catch.  Reproduced here.
--
Michael
Attachment

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #18240: Undefined behaviour in cash_mul_flt8() and friends
Next
From: PG Bug reporting form
Date:
Subject: BUG #18241: PushTransaction may cause Standby to execute ItemIdMarkDead