Re: Negative value of numGroups

Поиск
Список
Период
Сортировка
От Andrey Lepikhov
Тема Re: Negative value of numGroups
Дата
Msg-id 26c0c627-65a9-9e38-07f0-56861b75fc68@postgrespro.ru
обсуждение исходный текст
Ответ на Re: Negative value of numGroups  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Negative value of numGroups  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
On 5/17/22 20:34, Tom Lane wrote:
> Andrey Lepikhov <a.lepikhov@postgrespro.ru> writes:
>> On 13/5/2022 11:56, Andrey Lepikhov wrote:
>>> (long) Min(numGroups, (double) LONG_MAX);
>>>
>>> can return negative value, if numGroups > LONG_MAX.
> 
> I see your point, but I don't think that repeating the same finicky
> and undocumented coding pattern in multiple places is a future-proof
> fix.  I'm inclined to think we should invent a function along the
> lines of "long clamp_double_to_long(double x)".  Given where it's
> used, maybe putting it beside clamp_row_est() would be good.
> 
>             regards, tom lane
Next version of the patch.
As I see, now we trying to use Cardinality type instead of double.
So, I named casting routine as clamp_cardinality_to_long.

-- 
Regards
Andrey Lepikhov
Postgres Professional
Вложения

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Implicitly created operator family not listed by pg_event_trigger_ddl_commands
Следующее
От: PG Bug reporting form
Дата:
Сообщение: BUG #17486: [pg_restore] Restoring a view fails if this view contains an attribute without alias name.