BUG #14663: Unexpected rounding changes for money type divided by bigint

From: pistole(at)rhp(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #14663: Unexpected rounding changes for money type divided by bigint
Date: 2017-05-19 16:46:53
Message-ID: 20170519164653.29941.19098@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 14663
Logged by: Richard Pistole
Email address: pistole(at)rhp(dot)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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2017-05-19 17:02:47 Re: BUG #14662: 'has_table_privilege()' function fails with error, "invalid name syntax" when using Japanese symbols
Previous Message jmuise 2017-05-19 16:23:16 BUG #14662: 'has_table_privilege()' function fails with error, "invalid name syntax" when using Japanese symbols