Postgres Pro
Downloads
Home   >   mailing lists

Re: found a possible bug, modulus of an integer on a partition table appears to be wrong - Mailing list pgsql-bugs

From Tom Lane
Subject Re: found a possible bug, modulus of an integer on a partition table appears to be wrong
Date
Msg-id 3225216.1678059966@sss.pgh.pa.us
Whole thread Raw
In response to found a possible bug, modulus of an integer on a partition table appears to be wrong  ("Howard A. Chou" <maingroup@yahoo.com>)
List pgsql-bugs
Tree view 
"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 by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: BUG #17822: Some scripts are blocked by Device Guard
Next
From: Thomas Munro
Date:
Subject: Re: BUG #17368: Assert failed in GetSafeSnapshot() for SERIALIZABLE READ ONLY DEFERRABLE transaction