BUG #5993: pg_size_pretty overflow

Поиск
Список
Период
Сортировка
От nicola75ss
Тема BUG #5993: pg_size_pretty overflow
Дата
Msg-id 201104241817.p3OIHoZk039649@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #5993: pg_size_pretty overflow  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      5993
Logged by:          nicola75ss
Email address:      nicola75ss@gmail.com
PostgreSQL version: 8.4
Operating system:   windows 7
Description:        pg_size_pretty overflow
Details:

Good morning. I'm totally newbie with postgresql. I was studying
pg_size_pretty() and I've discovered that if I pass it a great value it
returns negative value.

This is an example

select pg_size_pretty(9223372000000000000); -- "-8388607 TB"

I've asked on stackoverflow

http://stackoverflow.com/questions/5768097/why-does-pg-size-pretty-return-ne
gative-value

and users suggest me to report this as a bug.
They say that the problem in the source code is here

else
  {
                     mult *= 1024;
                     snprintf(buf, sizeof(buf), INT64_FORMAT " TB",
                              (size + mult / 2) / mult); /* OVERFLOW! */
                 }
Regards. Nicola Cossu

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #5988: CTINE duplicates constraints
Следующее
От: Robert Haas
Дата:
Сообщение: Re: BUG #5988: CTINE duplicates constraints