Re: BUG #15475: Views over CITEXT columns return no data
| От | Paul Schaap |
|---|---|
| Тема | Re: BUG #15475: Views over CITEXT columns return no data |
| Дата | |
| Msg-id | 36CC8EE5-C6AB-475B-BC2D-D6BF39163D71@ipggroup.com обсуждение исходный текст |
| Ответ на | Re: BUG #15475: Views over CITEXT columns return no data (Andrew Gierth <andrew@tao11.riddles.org.uk>) |
| Ответы |
Re: BUG #15475: Views over CITEXT columns return no data
|
| Список | pgsql-bugs |
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@tao11.riddles.org.uk> wrote:"Paul" == Paul Schaap <ps@ipggroup.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.
В списке pgsql-bugs по дате отправления: