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

From: andrei(at)tchijov(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #7552: where clause gets ignored on one of view fields
Date: 2012-09-17 23:09:33
Message-ID: E1TDkRZ-0002HW-GT@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 7552
Logged by: Andrei Tchijov
Email address: andrei(at)tchijov(dot)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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Fujii Masao 2012-09-17 23:57:12 Re: BUG #7549: max_connections check should query master when starting standby
Previous Message diego_de_lima 2012-09-17 22:58:20 BUG #7551: Analyse of array domain types