Postgres Pro
Downloads
Home   >   mailing lists

numeric calculation bug as of 16.2-2 - Mailing list pgsql-bugs

From Huw Rogers
Subject numeric calculation bug as of 16.2-2
Date
Msg-id CACu6R2qT6nTTWWQ+VKRzCqnZFXJg99Q_8nv59Jy48nrzovOCTw@mail.gmail.com
Whole thread Raw
Responses Re: numeric calculation bug as of 16.2-2
List pgsql-bugs
Tree view
Straightforward calculation bug. ((2^127)/(2^63))*(2^63) != (2^127). This prevents a reliable uint128<->numeric cast function (which is how I ran into it). See below for test case. -Huw

] psql test
psql (16.2)
Type "help" for help.

test=# select ('170141183460469231731687303715884105727'::numeric / '9223372036854775808'::numeric) * '9223372036854775808'::numeric;
                ?column?                
-----------------------------------------
 170141183460469231731687303715884105728
(1 row)


pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: [EXTERNAL] Re: Windows Application Issues | PostgreSQL | REF # 48475607
Next
From: David Rowley
Date:
Subject: Re: numeric calculation bug as of 16.2-2