Merge join bug?

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Bugs for PostgreSQL <pgsql-bugs(at)postgreSQL(dot)org>
Subject: Merge join bug?
Date: 2006-03-17 05:18:17
Message-ID: 200603170518.k2H5IHA12945@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Someone has reported to me that VACUUM ANALYZE is causing different
results for the same query. They believe it is caused by merge join.

I tested in both 8.1.X and CVS HEAD and both appear to be affected. SQL
test attached.

--
Bruce Momjian http://candle.pha.pa.us
SRA OSS, Inc. http://www.sraoss.com

+ If your life is a hard drive, Christ can be your backup. +

Attachment Content-Type Size
unknown_filename text/plain 1.1 KB

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tomas Zerolo 2006-03-17 05:19:18 Re: BUG #2318: language
Previous Message Tom Hollins 2006-03-16 22:16:30 BUG #2327: Startup script for FC4 with selinux