[BUGS] BUG #14663: Unexpected rounding changes for money type divided bybigint

Поиск
Список
Период
Сортировка
От pistole@rhp.org
Тема [BUGS] BUG #14663: Unexpected rounding changes for money type divided bybigint
Дата
Msg-id 20170519164653.29941.19098@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: [BUGS] BUG #14663: Unexpected rounding changes for money type divided by bigint  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: jmuise@esri.com
Дата:
Сообщение: [BUGS] BUG #14662: 'has_table_privilege()' function fails with error,"invalid name syntax" when using Japanese symbols
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [BUGS] BUG #14662: 'has_table_privilege()' function fails with error, "invalid name syntax" when using Japanese symbols