| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp> |
| Cc: | David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>, Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>, Alan Jackson <ajax(at)tvsquared(dot)com>, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: inconsistent results querying table partitioned by date |
| Date: | 2019-05-16 20:37:50 |
| Message-ID: | 26062.1558039070@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
I wrote:
> So, the changes in gen_prune_steps_from_opexps seem okay, but
> the change in perform_pruning_base_step is just wrong,
I went ahead and pushed the non-controversial part of that patch,
just to avoid carrying it around longer.
I propose that we use the attached test cases once we have a fix
for the remaining problem. The results shown are the wrong answers
that HEAD produces. Amit's patch fixes the first case but not the
second, since substituting equality semantics is the right thing
to do in only the first case.
regards, tom lane
| Attachment | Content-Type | Size |
|---|---|---|
| test-case.patch | text/x-diff | 2.8 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2019-05-16 22:50:50 | Re: inconsistent results querying table partitioned by date |
| Previous Message | Tom Lane | 2019-05-16 19:25:35 | Re: inconsistent results querying table partitioned by date |