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

Hi Andrew,

Bingo, set enable_parallel_hash=false; gets a correct result whereas set enable_parallel_hash=true; gets 0.

Yes I might have reversed some of the explains, my excuse its Friday and I went to bed late and am burnt out today :-)

CHEERS
Paul

> On 2 Nov 2018, at 11:07, 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> Here you go:
>
> This is looking like a bug in parallel hash. Do the queries all work if
> you do set enable_parallel_hash=false; ?
>
> (Going by the row counts in the explains, you got the first two "broken"
> and "working" ones backwards)
>
> --
> Andrew.

--

PRIVACY & CONFIDENTIALITY NOTICE

The information contained in this
email is intended for the named recipients  only.  It may contain
privileged and confidential information and if you are  not the intended
recipient, you should not copy it or disclose its contents  to any other
person, or take any action in reliance on it.  If you have  received this
email in error, please notify us immediately by return email.