BUG #7552: where clause gets ignored on one of view fields

Поиск
Список
Период
Сортировка
От andrei@tchijov.com
Тема BUG #7552: where clause gets ignored on one of view fields
Дата
Msg-id E1TDkRZ-0002HW-GT@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #7552: where clause gets ignored on one of view fields  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      7552
Logged by:          Andrei Tchijov
Email address:      andrei@tchijov.com
PostgreSQL version: 9.2.0
Operating system:   Ubuntu 11.10
Description:        =


In a view (can provide source upon request) where condition on one of
columns gets ignored by select. No errors at all. Select runs as if the
condition is not present. Where conditions on other columns work as
expected.

The very same view functions as it should in 9.1 and 9.0.

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

Предыдущее
От: te
Дата:
Сообщение: Re: how to proccess record returning null
Следующее
От: "McGehee, Robert"
Дата:
Сообщение: Incorrect Sort Using Index Scan