At Tue, 09 Apr 2019 17:37:25 +0900 (Tokyo Standard Time), Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp> wrote in
<20190409.173725.31175835.horiguchi.kyotaro@lab.ntt.co.jp>
> > I'm attaching the latest version. Could you please check it again?
By the way, I noticed that partition constraint in a multi-level
partition contains duplicate clauses.
create table p (a int) partition by range (a);
create table c1 partition of p for values from (0) to (10) partition by range (a);
create table c11 partition of c1 for values from (0) to (2) partition by range (a);
create table c12 partition of c1 for values from (2) to (4) partition by range (a);
=# \d+ c12
| Partitioned table "public.c12"
| Column | Type | Collation | Nullable | Default | Storage | Stats target | De
| scription
| --------+---------+-----------+----------+---------+---------+--------------+---
| ----------
| a | integer | | | | plain | |
| Partition of: c1 FOR VALUES FROM (2) TO (4)
| Partition constraint: ((a IS NOT NULL) AND (a >= 0) AND (a < 10) AND (a IS NOT N
| ULL) AND (a >= 2) AND (a < 4))
| Partition key: RANGE (a)
| Number of partitions: 0
The partition constraint is equivalent to "(a IS NOT NULL) AND (a
>= 2) AND (a < 4)". Is it intentional (for, for example,
performance reasons)? Or is it reasonable to deduplicate the
quals?
regards.
--
Kyotaro Horiguchi
NTT Open Source Software Center