Re: BUG #7604: adding criteria to a query against a view in 9.2 expands the results instead of constraining them

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #7604: adding criteria to a query against a view in 9.2 expands the results instead of constraining them
Дата
Msg-id 13773.1350317896@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #7604: adding criteria to a query against a view in 9.2 expands the results instead of constraining them  (webmaster@dhs-club.com)
Ответы Re: BUG #7604: adding criteria to a query against a view in 9.2 expands the results instead of constraining them  (Bill MacArthur <webmaster@dhs-club.com>)
Список pgsql-bugs
webmaster@dhs-club.com writes:
> vip_declines_mailers_base is another VIEW that merely adds some criteria to
> limit the result set of the 'base' VIEW. In versions 9.0 and back it did
> just that. After upgrading to 9.2, the criteria actually expand the result
> set.

This doesn't seem to match any of the known bugs in 9.2, so I'm afraid
there's no help for it: you need to create a self-contained test case.

            regards, tom lane

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

Предыдущее
От: webmaster@dhs-club.com
Дата:
Сообщение: BUG #7604: adding criteria to a query against a view in 9.2 expands the results instead of constraining them
Следующее
От: Fujii Masao
Дата:
Сообщение: Re: BUG #7534: walreceiver takes long time to detect n/w breakdown