pgsql-server: Hashed LEFT JOIN would miss outer tuples with no inner

Поиск
Список
Период
Сортировка
От tgl@svr1.postgresql.org (Tom Lane)
Тема pgsql-server: Hashed LEFT JOIN would miss outer tuples with no inner
Дата
Msg-id 20040917182854.5ACD3329DFC@svr1.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Дерево обсуждения 
Log Message:
-----------
Hashed LEFT JOIN would miss outer tuples with no inner match if the join
was large enough to be batched and the tuples fell into a batch where
there were no inner tuples at all.  Thanks to Xiaoyu Wang for finding a
test case that exposed this long-standing bug.

Modified Files:
--------------
    pgsql-server/src/backend/executor:
        nodeHashjoin.c (r1.64 -> r1.65)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/executor/nodeHashjoin.c.diff?r1=1.64&r2=1.65)

В списке pgsql-committers по дате отправления:

Предыдущее
От: tgl@svr1.postgresql.org (Tom Lane)
Дата:
Сообщение: pgsql-server: Now that xmax and cmin are distinct fields again, we
Следующее
От: tgl@svr1.postgresql.org (Tom Lane)
Дата:
Сообщение: pgsql-server: Hashed LEFT JOIN would miss outer tuples with no inner