| From: | Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com> |
|---|---|
| To: | Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk> |
| Cc: | ps(at)ipggroup(dot)com, Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: BUG #15475: Views over CITEXT columns return no data |
| Date: | 2018-11-02 01:29:47 |
| Message-ID: | CAEepm=2hQsjCv0yaoFUE2xdC+Ow8MNjShZHiUADb4uC4vMsibQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Fri, Nov 2, 2018 at 2:07 PM Andrew Gierth
<andrew(at)tao11(dot)riddles(dot)org(dot)uk> wrote:
> >>>>> "Paul" == Paul Schaap <ps(at)ipggroup(dot)com> writes:
> Paul> Hi Andrew,
> Paul> Bingo, set enable_parallel_hash=false; gets a correct result
> Paul> whereas set enable_parallel_hash=true; gets 0.
>
> Paul> Yes I might have reversed some of the explains, my excuse its
> Paul> Friday and I went to bed late and am burnt out today :-)
>
> Are all the values of the my_citext column actually null?
Thanks for the report Paul and the analysis Andrew. Discussed with
Andrew a bit on IRC. Summary: multi-batch left joins are not handling
NULLs correctly in the left table when partitioning. Looking into
this now.
--
Thomas Munro
http://www.enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amit Langote | 2018-11-02 01:54:41 | Re: BUG #15437: Segfault during insert into declarative partitioned table with a trigger creating partition |
| Previous Message | Andrew Gierth | 2018-11-02 01:07:08 | Re: BUG #15475: Views over CITEXT columns return no data |