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 :-)
"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.