Alexander Korotkov <a.korotkov@postgrespro.ru> writes:
> I've reproduced this bug on d981074c.
> On default config, after loading example.sql.bz2 and VACUUM ANALYZE, query
> result is OK.
> But with seqscan and hashjoin disabled, query returns 0 rows.
Ah, thanks for the clue about enable_hashjoin, because it wasn't
reproducing for me as stated.
It looks like in the case that's giving wrong answers, the mergejoin
is wrongly getting marked as "Inner Unique". Something's a bit too
cheesy about that planner logic --- not sure what, yet.
regards, tom lane
