Outer join does not report rows with null values

Поиск
Список
Период
Сортировка
От pgsql-bugs@postgresql.org
Тема Outer join does not report rows with null values
Дата
Msg-id 200105300727.f4U7R7M08480@hub.org
обсуждение исходный текст
Список pgsql-bugs
Mirek Hankus (M.Hankus@ce3.pl) reports a bug with a severity of 4
The lower the number the more severe it is.

Short Description
Outer join does not report rows with null values

Long Description
I'm running two databases (7.1.2). Same structure, the only difference is data stored in them. When I run same query
withouter join  
it returns only rows with coresponding rows in both tables, and no rows with null values (as it should report). In the
otherdatabase query works fine (returns coresponding rows and rows with no coresponding values).  
I'know that it is impospble to reproduce, so I report it only for your information.


Sample Code


No file was uploaded with this report

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

Предыдущее
От: Maxim Maletsky
Дата:
Сообщение: a typo in Docs, 7.1
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: a typo in Docs, 7.1