Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #15475: Views over CITEXT columns return no data - Mailing list pgsql-bugs

From Andrew Gierth
Subject Re: BUG #15475: Views over CITEXT columns return no data
Date
Msg-id 87bm7847dk.fsf@news-spur.riddles.org.uk
Whole thread Raw
In response to Re: BUG #15475: Views over CITEXT columns return no data  (Paul Schaap <ps@ipggroup.com>)
Responses Re: BUG #15475: Views over CITEXT columns return no data  (Thomas Munro <thomas.munro@enterprisedb.com>)
List pgsql-bugs
Tree view 
>>>>> "Paul" == Paul Schaap <ps@ipggroup.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)

pgsql-bugs by date:

Previous
From: Paul Schaap
Date:
Subject: Re: BUG #15475: Views over CITEXT columns return no data
Next
From: Thomas Munro
Date:
Subject: Re: BUG #15475: Views over CITEXT columns return no data