From: | Yudianto Prasetyo <mr(dot)yudianto(at)gmail(dot)com> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Subject: | bugs or my fault |
Date: | 2021-09-15 06:28:27 |
Message-ID: | CAN7WH3LSsm3q_A___SO6=gvOn4-fKCsQvD3E3JrJkTVDm_SbUA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hello,
can you explain if this is a bug or my fault ?
I'm making a simple example of hash partition
CREATE TABLE myschema.customers(
id int,
status text,
arr numeric
) PARTITION BY HASH(id);
CREATE TABLE myschema.cust0 PARTITION OF myschema.customers
FOR VALUES WITH (modulus 3, remainder 0);
CREATE TABLE myschema.cust1 PARTITION OF myschema.customers
FOR VALUES WITH (modulus 3, remainder 1);
CREATE TABLE myschema.cust2 PARTITION OF myschema.customers
FOR VALUES WITH (modulus 3, remainder 2);
INSERT INTO myschema.customers VALUES (1,'ACTIVE',100), (2,'RECURRING',20),
(3,'EXPIRED',38), (4,'REACTIVATED',144);
when I run the query, the result is:
2 "RECURRING" 20
4 "REACTIVATED" 144
shouldn't be
3 "EXPIRED" 38
i run this in version
PostgreSQL 13.4, compiled by Visual C++ build 1914, 64-bit
Please help me
From | Date | Subject | |
---|---|---|---|
Next Message | Yudianto Prasetyo | 2021-09-15 06:30:36 | Re: bugs or my fault |
Previous Message | Tom Lane | 2021-09-14 21:56:58 | Re: BUG #15293: Stored Procedure Triggered by Logical Replication is Unable to use Notification Events |