| 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: | Whole Thread | Raw Message | 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 |