Re: found a possible bug, modulus of an integer on a partition table appears to be wrong

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: found a possible bug, modulus of an integer on a partition table appears to be wrong
Дата
Msg-id 3225216.1678059966@sss.pgh.pa.us
обсуждение исходный текст
Ответ на found a possible bug, modulus of an integer on a partition table appears to be wrong  ("Howard A. Chou" <maingroup@yahoo.com>)
Список pgsql-bugs
Дерево обсуждения 
"Howard A. Chou" <maingroup@yahoo.com> writes:
> The remainder of 4, 6, 8 mod 2 should be 0.  Instead of inserting into t1_0, all values were inserted into t1_1

You are confusing "modulus of the column value" with "modulus of
the hash of the column value".  The latter is what determines
tuple routing in a hash-partitioned table.

            regards, tom lane

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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: BUG #17822: Some scripts are blocked by Device Guard
Следующее
От: Thomas Munro
Дата:
Сообщение: Re: BUG #17368: Assert failed in GetSafeSnapshot() for SERIALIZABLE READ ONLY DEFERRABLE transaction