BUG #15357: Data goes to wrong partition in HASH Partitioned table
От | PG Bug reporting form |
---|---|
Тема | BUG #15357: Data goes to wrong partition in HASH Partitioned table |
Дата | |
Msg-id | 153547013018.1489.10425888757862385184@wrigleys.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #15357: Data goes to wrong partition in HASH Partitionedtable
|
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 15357 Logged by: Jobin Augustine Email address: jobin.augustine@percona.com PostgreSQL version: 11beta3 Operating system: Linux (CentOS 7.4 64 bit) Description: Steps to reproduce ============= Step 1. Create a hash partitioned table postgres=# CREATE TABLE hash_parted ( postgres(# a int postgres(# ) PARTITION BY HASH (a); CREATE TABLE Step 2. Create a partition which accpets rows with remainder 0 after a modulus operation postgres=# CREATE TABLE hpart_1 PARTITION OF hash_parted FOR VALUES WITH (MODULUS 10, REMAINDER 0); CREATE TABLE Step 3. Try inserting a row which will have remainder 0 after modulus operation postgres=# insert into hash_parted values (10); ERROR: no partition of relation "hash_parted" found for row DETAIL: Partition key of the failing row contains (a) = (10). FAILED! Step 4. Create a partition which accepts the remainder 9 after modulo operation postgres=# CREATE TABLE hpart_10 PARTITION OF hash_parted FOR VALUES WITH (MODULUS 10, REMAINDER 9); CREATE TABLE Step 5. Try inserting a value 10 postgres=# insert into hash_parted values (10); INSERT 0 1 Data gets inserted into a partition which is supposed to accept reminder 9 after modulo operation.
В списке pgsql-bugs по дате отправления: