Re: BUG #15933: Partition by multiple columns bug - Mailing list pgsql-bugs

From Damir Ciganović-Janković
Subject Re: BUG #15933: Partition by multiple columns bug
Date
Msg-id CA+-2sJ7Sgb9pOkcf_bkj6uw6W-SdC8xVz0L-u2-72+a6ha_wOA@mail.gmail.com
Whole thread Raw
In response to Re: BUG #15933: Partition by multiple columns bug  (Amit Langote <amitlangote09@gmail.com>)
List pgsql-bugs
Hi, I tried it with 11.4 and it worked, thanks 

Kind regards,
Damir

On Wed, Jul 31, 2019 at 6:58 AM Amit Langote <amitlangote09@gmail.com> wrote:
On Tue, Jul 30, 2019 at 11:34 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
> PG Bug reporting form <noreply@postgresql.org> writes:
> > -- fourth query that completely fails to find partition
> > EXPLAIN ANALYZE SELECT * from my_table WHERE my_enum = 'FIRST' AND my_time >
> > now();
> > Result  (cost=0.00..0.00 rows=0 width=16) (actual time=0.001..0.001 rows=0
> > loops=1)
> >    One-Time Filter: false
> > This seems like a bug to me.
>
> In v11 branch tip I get
>
>  Append  (cost=0.00..42.39 rows=3 width=16) (actual time=0.007..0.007 rows=0 loops=1)
>    ->  Seq Scan on my_table_first  (cost=0.00..42.38 rows=3 width=16) (actual time=0.006..0.006 rows=0 loops=1)
>          Filter: ((my_enum = 'FIRST'::enum1) AND (my_time > now()))
>
> and in HEAD it looks like
>
>  Seq Scan on my_table_first  (cost=0.00..42.38 rows=3 width=16) (actual time=0.007..0.007 rows=0 loops=1)
>    Filter: ((my_enum = 'FIRST'::enum1) AND (my_time > now()))
>
> so evidently this is already fixed.

Yeah, I think we fixed this particular issue in 6630ccad7a [1] that
appeared in the 11.4 release.

Thanks,
Amit

[1] https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=6630ccad7a

pgsql-bugs by date:

Previous
From: Amit Langote
Date:
Subject: Re: BUG #15933: Partition by multiple columns bug
Next
From: Andrey Borodin
Date:
Subject: Re: Logging corruption error codes