[BUGS] BUG #14663: Unexpected rounding changes for money type divided bybigint - Mailing list pgsql-bugs

From pistole@rhp.org
Subject [BUGS] BUG #14663: Unexpected rounding changes for money type divided bybigint
Date
Msg-id 20170519164653.29941.19098@wrigleys.postgresql.org
Whole thread Raw
Responses Re: [BUGS] BUG #14663: Unexpected rounding changes for money type divided by bigint  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      14663
Logged by:          Richard Pistole
Email address:      pistole@rhp.org
PostgreSQL version: 10beta1
Operating system:   Centos 7
Description:

Running the following query:

select 878.08::money/11::bigint;

Returns this following result in 9.6.3:

$79.83

In 10beta1, it returns:

$79.82

I think this may be related to this commit and doing the running sums as
negatives, but I'm not sure:

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=656df624c0d7b50e1714f2a3a14e143e63799a80





--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

pgsql-bugs by date:

Previous
From: jmuise@esri.com
Date:
Subject: [BUGS] BUG #14662: 'has_table_privilege()' function fails with error,"invalid name syntax" when using Japanese symbols
Next
From: Tom Lane
Date:
Subject: Re: [BUGS] BUG #14662: 'has_table_privilege()' function fails with error, "invalid name syntax" when using Japanese symbols