Re: bugs or my fault

sorry I miss the query

select * from myschema.cust0;

On Wed, Sep 15, 2021 at 1:28 PM Yudianto Prasetyo <mr(dot)yudianto(at)gmail(dot)com>
wrote:

> 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
>