BUG #8196: problem with left join and is null check

Поиск
Список
Период
Сортировка
От aray1985@yahoo.com
Тема BUG #8196: problem with left join and is null check
Дата
Msg-id E1UiQr6-0008IE-IG@wrigleys.postgresql.org
обсуждение исходный текст
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      8196
Logged by:          Ara
Email address:      aray1985@yahoo.com
PostgreSQL version: 9.1.9
Operating system:   ubuntu
Description:        =


I have to tables which I'm joining with left join query.

SELECT count(*) FROM
table A LEFT JOIN table B ON ...

result has 200 000 rows, for 190 000 of them there is no value for columns
of table B (result of join)

ISSUE: When I'm trying to filter result with WHERE B.some_column IS NULL
query works more then 5 min (never waited for result). =


MORE INFO:
When I'm filtering results with WHERE B.some_column IS NULL OR B.some_column
=3D 'some value that some_column would never had' the query takes 2 second =
and
gives normal result (190 000).

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

Предыдущее
От: daniel.couto.2@hotmail.com
Дата:
Сообщение: BUG #8194: hardware
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #8191: Wrong bit conversion