Alexander Korotkov <a.korot...@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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
