Quick Links

Re: BUG #15475: Views over CITEXT columns return no data

From:	Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
To:	Paul Schaap <ps(at)ipggroup(dot)com>
Cc:	Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>, Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject:	Re: BUG #15475: Views over CITEXT columns return no data
Date:	2018-11-02 01:07:08
Message-ID:	87bm7847dk.fsf@news-spur.riddles.org.uk
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-bugs

>>>>> "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?

--
Andrew (irc:RhodiumToad)

	From	Date	Subject
Next Message	Thomas Munro	2018-11-02 01:29:47	Re: BUG #15475: Views over CITEXT columns return no data
Previous Message	Paul Schaap	2018-11-02 00:30:17	Re: BUG #15475: Views over CITEXT columns return no data