[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-bugs
Subject:    Re: BUG #15933: Partition by multiple columns bug
From:       Damir Ciganović-Janković <damir.ciganovic.jankovic () gmail
Date:       2019-07-31 5:26:15
Message-ID: CA+-2sJ7Sgb9pOkcf_bkj6uw6W-SdC8xVz0L-u2-72+a6ha_wOA () mail ! gmail ! com
[Download RAW message or body]

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
>

[Attachment #3 (text/html)]

<div dir="ltr">Hi, I tried it with 11.4 and it  worked, thanks  \
<div><br></div><div>Kind  regards,</div><div>Damir</div></div><br><div \
class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Jul 31, 2019 at 6:58 AM \
Amit Langote &lt;<a href="mailto:amitlangote09@gmail.com">amitlangote09@gmail.com</a>&gt; \
wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">On Tue, Jul 30, 2019 \
at 11:34 PM Tom Lane &lt;<a href="mailto:tgl@sss.pgh.pa.us" \
target="_blank">tgl@sss.pgh.pa.us</a>&gt; wrote:<br> &gt; PG Bug reporting form \
&lt;<a href="mailto:noreply@postgresql.org" \
target="_blank">noreply@postgresql.org</a>&gt; writes:<br> &gt; &gt; -- fourth query \
that completely fails to find partition<br> &gt; &gt; EXPLAIN ANALYZE SELECT * from \
my_table WHERE my_enum = &#39;FIRST&#39; AND my_time &gt;<br> &gt; &gt; now();<br>
&gt; &gt; Result   (cost=0.00..0.00 rows=0 width=16) (actual time=0.001..0.001 \
rows=0<br> &gt; &gt; loops=1)<br>
&gt; &gt;      One-Time Filter: false<br>
&gt; &gt; This seems like a bug to me.<br>
&gt;<br>
&gt; In v11 branch tip I get<br>
&gt;<br>
&gt;   Append   (cost=0.00..42.39 rows=3 width=16) (actual time=0.007..0.007 rows=0 \
loops=1)<br> &gt;      -&gt;   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)<br> &gt;               Filter: \
((my_enum = &#39;FIRST&#39;::enum1) AND (my_time &gt; now()))<br> &gt;<br>
&gt; and in HEAD it looks like<br>
&gt;<br>
&gt;   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)<br> &gt;      Filter: ((my_enum = \
&#39;FIRST&#39;::enum1) AND (my_time &gt; now()))<br> &gt;<br>
&gt; so evidently this is already fixed.<br>
<br>
Yeah, I think we fixed this particular issue in 6630ccad7a [1] that<br>
appeared in the 11.4 release.<br>
<br>
Thanks,<br>
Amit<br>
<br>
[1] <a href="https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=6630ccad7a" \
rel="noreferrer" target="_blank">https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=6630ccad7a</a><br>
 </blockquote></div>



[prev in list] [next in list] [prev in thread] [next in thread]